-
Turn Date into numeric value
I would like to follow a task and see the difference between when it was planned and actually done. To be more precise. Column "Agreed Date" is used on what date the two parties agreed to finish the task Colum "Final Date" should show what day the task was really done. This should not change based on date, but should be a…
-
Nested Ifs checking for different conditions
Hello, I am trying to add an additional argument to a formula to check if a cell called "Awaiting Response" is not blank, and if so, change a RYG cell to yellow instead of red, but I am getting either #UNPARSABLE or #INCORRECT ARGUMENT SET. The conditions are all based on when the last response was to a ticket, with more…
-
At Risk Flag Formula Help
Hello, I currently am using the below formula in the At Risk column which works just fine. If baseline due date is 3 days out and status is not checked off as complete as well as % complete is not 100%, flag as at risk. =IF(AND([Baseline Due Date]@row <= TODAY(3), [Baseline Due Date]@row >= TODAY(), Status@row <> "Yes", [%…
-
How to apply the same 5 different criteria's in conditional formatting for multiple columns quicker
Hi, I have set up a smartsheet to measure the performance of staff. So 0 = not evident 1= somewhat evident 2 = Evident 3= Above Expected Once the performance of a staff is observed, the observer keys in either, 0, 1, 2 or 3 etc under the persons name. There are over 30 different criteria's to look at. So Mary might be a 1…
-
Email from Rule
Hi everyone, I have a rule set up to send me an email whenever a row is added. I'm not sure why, but when the email comes through, the fields are highlighted in yellow. Is there a way that the information comes through without being highlighted? Is the rule correct? Attached are images of the email and the workflow. Thanks…
-
If Status is "Complete" Fill in #of Stores information into "# Stores Complete
Hello, I am looking for help writing a formula for: IF Status = Complete - pull value from # of Stores into #Stores Complete Column. Thanks, Molly Morton
-
Formulas Not Autofilling With Form Submission
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula. According to this help article, it should be autofilling the formula into the new row. What has been driving me crazy was…
-
COUNTIFS HELP!
Hello, I'm attempting to write a formula that says count if this branch is rendered but not if this column shows "PTB"... I got the first part to work and it counts if the branch is in there but cannot get it to not count those with PTB in the PTB? column. if you need any further explanation please let me know! Logic:…
-
One Dependency for the start, another for the end?
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that continue after the on-site work is done, but I won't have to continue the update…
-
Help with formula with RYG Balls and Start/End Dates
Hello, I am trying to clean up a program management smartsheet. I am wanting the status column (RYG balls) to communicate with the % complete column and the start and end date column. This is my current formula: =IF([% Complete]93 = 1, "Green", IF([% Complete]93 > 0.49, "Yellow", IF([% Complete]93 < 0.48, "Red"))) With…