Hey there,
I would like to show:
Total Number of Vendors
Defined as the # of vendors in each cohort. This lives on a tab called “Vendor - Main View”
Total Number of those Vendors with Completed “AERs”
AER Completion is defined as a date correspondin...
Hello! Here’s what I’m hoping to accomplish:
If {Inventory Arrived?} = ‘Inventory Arrived’ and HAS a date in {When did Inventory Land?} use that date.If {Inventory Arrived?} = ‘Inventory Arrived’ and DOESN’T have a date, use {Updated Estimated Deliv...
Hey there,
I’m looking to capture:
Total Number of Vendors (1st column) that are in each Lifecycle Stage (Ex: 2 in PO Launched, 1 in PO Placed) andThe % of vendors relative to the total (Ex: 40% of all vendors have a Lifecycle Stage of PO Launched)
Q...
Hey team!
When a new record is added, I would like for a drop down option to be automatically selected.
For example: When the record for Aqua Lily Pad is added, I’d like “Inventory Arrived?” to automatically select “Inventory Not Arrived” (option not...
Hey there,
I need to show the most current step in progress in my “Is Current Step?” formula as “1”. I’m running into an issue with my current formula because some of the Upcoming Due Date Lookup dates are the same. (Example below for the Content Qua...
Thanks, Jeremy. I should have mentioned that one of the end goals is that the % can be a field tied to the vendor, so that we can export the csv with that %. Knowing that, do you have a different suggestion?
Again, I appreciate your patience!
I’m okay to show the %s on the Lifecycle page.
Forgive my ignorance, but I can’t seem to re-create the total of vendors (from sum table) - do I need to link / associate differently?
Thank you!
I’m looking to show the % of vendors in each lifecycle. As you can see below, the total doesn’t equal 100%. Is that possible? Ideally I’d like to show that 20% of vendors are in PO Placed, 40% are in PO Launched (not 80%, as it shows when ...
Thank you so much for the help! I’m having a hard time with summing the entire field.
My issue is that I’m not adding up the Lookup Count (which totals 7), instead I want to add up the Count (in Lifecycle Stage, which totals 5).
Is that possible? I’d...
Thanks! A few things:
There will be multiple vendors added periodically, so what I’d like it to say is… “when any vendor is added (through the form view), those two drop downs columns will automatically be selected with their specific selections”
And...
