-
Conditional Formatting Based on Row Action Indicators
Does anyone know if it is possible to apply conditional formatting based on row action indicators? I would specifically like to increase the visibility of an overallocated resource on a sheet by turning the cell red. If conditional formatting cannot be applied based on the overallocation indicator directly, is there some…
-
Receiving an error message when trying to edit/save automations created by someone else
We are having issues editing automations that have been created by someone else. If someone other than the original person who created the automation goes in to try and edit & save they receive the error message saying "sorry, we are having trouble reaching Smartsheet right now....." The person who created the automation…
-
Error code for date formula
Good morning, I'm hoping someone can help me with this formula (formulas are not my strongest area, can you tell? Yikes!). I need to count the number of days between two approval dates. This is the formula: =ABS([Mgr Approval Date]@row - [Exec Approval Date]@row) It works, unless one of the date columns is blank. I've…
-
Smartsheet Summary RYG across multiple sheets/cells
I want to provide an overall RYG status tied to multiple sheets. What is the best reference for determining the formula to do so?
-
Hiding form drop downs based on prior submissions
I'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents. Is there a way to accomplish this?
-
Can I use the "IF" function to create categories in a single column?
I'm doing this formula but I only received the first two criteria. What I'm doing wrong =IF([Days to Target Due Date]@row > 60, "More than 60 days for Due date", IF([Days to Target Due Date]@row <= 60, "Less than 60 days for due date", (IF([Days to Target Due Date]@row <= 30, "Less than 30 days for due date", IF([Days to…
-
Need a check mark for rows added last month
I want a checkmark to appear when entries were created the previous month. i.e., all April entries would have a checkmark, and starting June 1, only May entries, and so on. I thought the following formula was a good place to begin, but apparently the -1 is only subtracting a day, not a month. =IF(MONTH([Entry Date]@row) =…
-
RYG Balls in IF(AND Formula
I am trying to automate the RYG balls to reflect a result based on up to two columns. All of the possibilities are: Green: [Expiration Date]97 is in the future or equal to TODAY Yellow: [Expiration Date]97 is within 30 days of TODAY Red: [Expiration Date]97 has already passed and [Renew] = "No" Related question: is it…
-
COUNTIFS functionality for multiple entries
New to SmartSheet and I promise I have been looking around for an answer, but without any luck so I thought I would throw it out to the community... I am looking to sum up all entries in column in a summary total at the top of my sheet, but the formula I have is only calculating where the searched for text is alone in the…
-
I need to skip blank columns in rows
This is my current formula: =IF(AND([BO1 approval]@row = "Approved", [BO2 approval]@row = "Approved", [BO3 approval]@row = "Approved"), "Approved", IF(OR([BO1 approval]@row = "Denied", [BO2 approval]@row = "Denied", [BO3 approval]@row = "Denied"), "Denied", "Submitted")) How it works: If all approvers hits "Approved"…