Summer
Summer
Reactions
-
Re: Can you run a formula if and only if the number is negative?
Hi @Andrea Westrich, I think we can take a really simply approach to this and adjust the formula in the "Credit Card Receipts" to have a max of 20. =IF(20 - Score1 > 20, 20, 20 - Score1)…1 · -
Re: Multi dropdown on report
Hi @fionam_c One work around may be to create a helper column that pulls the value from the phase drop down. Then use that helper column on the report instead of the drop down column. Example: =phase…1 · -
Re: countif with > or < signs
Hi @Nabil Hayek, You could use the CONTAINS function to achieve this. The formula would look like this =COUNTIF(range, (CONTAINS("3 hours", @cell))) More information on the CONTAINS functio…1 · -
Re: Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
Hi @M.Q. Try it without the AND statement. =IF(Status@row = "Not Started", "Red", IF(Status@row = "Completed", "Green", IF(Status@row = "In Progress"…1 · -
Re: Formula for automatically pulling rows of data from one sheet to another using checkbox
The simplest way to do this depending on how many columns are on Sheet A and Sheet B would be to use Smartsheets built in workflow for moving or copying rows of data. If you'd like to use a formula t…1 ·
