-
Formula to change the Health status of my projects based on data from two cells
I'm trying to get a formula that will change the Color dot in my Project health status field, based on conditions in two other cells. What I want is: If the "Project Status" field = Active or On Hold, AND the "Project Wrap Date" field is Today (7), change the Health Status field to a Yellow dot; or if the "Project Status"…
-
Increasing and Decreasing Totals
My smartsheet calculates points based on employee call-ins. When the points total changes/goes above 8, we send an email stating that the employee reached between 8 and 9.5 in half point increments. The question has come up where an employee is at 8.5 and then points get updated down to 8, another email is sent for review.…
-
Linking / Updating Sheets
Afternoon All - I have a slightly complex question I wanted to pose to the community to see if I could get some thoughts. I have two sheets that I want to have "talk" to each other. One Sheet (Master Sheet), is where our team spends their day looking for requests to come through. In a second sheet (Change Requests Sheet),…
-
How do I create an auto numbering system based on a value in another column?
I have a form connected to my smartsheet. I want a column (this example "Count") to auto number based on what another cell in a specific column has. For example, one column has either 'apple' or 'orange' displayed. I want another column to keep a count each time a row is added from the form, with either apple or orange.…
-
What is wrong with this formula?
I'm trying to change the status based on % complete column: =IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF(AND([Percent Complete]@row < 1, [Finish Date]@row < TODAY()), "Delayed", IF(AND([Percent Complete]@row < 0.5, [Finish Date]@row <= TODAY(5)), "At Risk", IF(AND([Percent…
-
Conditional formatting: higher rules vs lower rules
Hi, I have created a helper column with checkbox to aid in only applying the conditional formatting I need to specific rows. I was able to get rules 1, 2 and 3 to work but not the last rule, screenshot below. My question is how do I need to arrange these rules so I can get the negative amount at the far bottom right to…
-
Duplicate values
is it possible to let smartsheet read the content of a cell and compare it with the content of a specific place on PDF? afterwards light up the duplicate values i the smartsheet cell
-
How to apply conditional formatting on cross sheet reference (dates)?
Hello, Can anyone help me with figuring out how to apply conditional formatting to cross sheet references (dates)? I am realizing that even if the column is set up as a date, Smartsheet is not reading the cross sheet reference (these are vlookup and index-match formulas) as a date, and I cannot format. I tried creating a…
-
Extract Series of Occurrences of Strings into Separate Columns
Hi @Paul Newcome , You mentioned in another thread here: https://community.smartsheet.com/discussion/63606/extracting-string-from-a-cell? "If you wanted to parse them out across individual columns, we would instead use a series of LEFT/FIND and MID/FIND statements." The previous thread looked to me like someone was using…
-
join, collect with multiple entries
This formula in the "Also Notified" column works perfectly for one "Deputy" with one or more "Deputy Back-Up Contacts" =JOIN(COLLECT({Deputy Back-Up Contacts Range 4}, {Deputy Back-Up Contacts Range 1}, Deputy@row), ", ") However, when more than one Deputy is selected, the formula should return all the Back-Up Contacts for…
