-
How to loop through workflow
I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the system understands that it should again send an email for approval. I do not want to…
-
Flag by Last Modified Date Formula
Hi, I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days). Right now I have a flag column and a hidden modified date column. Any help with the formula please? Thank you! Jared
-
Conditional Formatting For Date Cell
Hi, I want to apply conditional formatting to a date cell if the date in that cell is earlier or later than a date in another cell. Can someone tell me if this is possible and if so how to do it? Thanks. -Marcia
-
Limiting tasks (by name) to specific days of the week
Hi, I'm looking for a way to control specific tasks being allowed to start on only certain days of the week. For instance, a task name containing "A" is not allowed to occur on Mon or Fri, only possible to start/finish on Tue, Wed, or Thu. Keep in mind, A is a precedent for B, which is a precedent for C. But B and C are…
-
Checking Done for multiple cells
Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula doesn't seem to work. Any thoughts? =IF([Column2]1 = "Done", 1, 0)
-
IF statement
I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet. Here are the conditions I want to test: 1) If today is less than or equal to 3 weeks from the submission date, turn the RYG ball…
-
Auto Numbering / System
Hi, I am wondering is there a way to have an auto numbering column where the display format is dependant on the value of another column. I have a "Type" column that is a dropdown with "Action" and "Decision" as the values. I would like the Auto number to display A-001 if this column is "Action" and D-001 if it…
-
Heath Calculation based on Critical Path Health
Hello! I'm wanting to calculate the health of my project based on the health of any task that is on the critical path. I have seen the blog post about being able to create a filter that is able to show the critical patch, but is there a way to derive via a formula if the task is on the critical path or not? I would…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Rows deleted when deleting columns connected to formatting
Hello smartsheet community, Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I opted to create separate column which contains those options. After clearing all of the "Done" column formatting I went…
