Sign in to join the conversation:
Hello, I am trying to build a formula that will do the following:
If either column is blank the health stays blank.
Hi Randy,
I was hunting back through the pages looking for unanswered threads and couldn't understand why this one had been orphaned.
The formula you're looking to stick in the first row of the Health column is:
=IF(AND([Yes/No]1 = "Yes", [Verification Check]1), "Green", "")
Then drag it down as far as necessary.
Kind regards,Chris McKayDown Under Smartsheet Support
Hi community i'm trying to create a formula that calculate a sum in a column based on may criteria. here is a screenshot of the affected column i want to calculate the "volume cumul" (sum of volume collected) based on Week Active should be "This Week" or "Next Week" same Unique ID should be calculated together if Unique ID…
Hi I am trying to work out a percentage for some KPIs. I have a sheet I am recording various KPI entries on (see below) I have a metrics sheet set up so, I can break the KPI results down by month by referencing this sheet. Taking KPI 1 (in the example shown above), I need a formula that will return a percentage of the…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
