-
Formula off multiple columns
I'm trying to build a formula that works off multiple columns to give one of the 6 state pain scale results (No pain -- extreme pain). Here's my formula:IF(Cancel@row = 1, "No Pain", IF(Suggested@row = 1, "No Pain", IF(TODAY() - [Date Requested by School]@row > 14, "Extreme", IF(ISBLANK([Airline Contract Attached to…
-
Countif but only if?
So I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether or not it should be included in the "tally". Ultimately, what I am trying to do would be if the…
-
RAG Status - Formula
Hi, I have currently formulated the following formula, =IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Date]1 - [Project Status %]1 <= 0.75), "Amber", "Red")) which is working efficiently, but problem occurs it shows me the…
-
Allowing Circular Reference
I would like to run a calculation with a circular reference =IF(Date1 = [1]1, 100 - Total1, [1]3). This allows me to keep the cell as is if the IF statement is false. Is this possible? [1]3 is the circular reference.
-
Asset Management Template
is there a template for asset managemen template, where you can check out and check in your asset?
-
Holding a calculation until specified date.
Hello, I would like to set up a row of cells to run a calculation at a specified date and time. If that is not tricky enough, I want that calculation to remain as is thereafter even though the data that the calculation uses would change frequently. Is there a way to prevent a cell from running a calculation until a…
-
Deactivate temporarly all "Alerts & Actions"
Hi all, i need to make some updates on my spreadsheets, that were not made on due time. But i don't want to confuse people by triggering notifications and alerts of actions already completed. Is there any way of deactivating all the "Alerts & Actions" at the same time, and then activating them again as soon as i got…
-
How to use Trend Arrows to show change in RYG
Is there a formula that would highlight the trend of a change in RYG balls ? For example, if someone changes the status of a project from Green to Red, it would show a down arrow. If someone changes the arrow from Red to Yellow, it would show a Upward arrow. Thanks for your help!
-
Question on multiple predecessors
Hello! When using 2 predessors for one row, smartsheet calculates the later start date. How can I manage to get the earlier start date. For me it sounds like a common requirement. Start as early as necessary to meet 2 alternative deadlines ... Kind regards Michael
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…