-
Workflow Triggers
Hello, is there any way i can trigger a workflow to notify me 90 days after the 'status' column we've got turns blue? (we're using the traffic light icons) Let me know if you can help - thanks!
-
Multiple IF/AND Statements Formula
Hi All, I have a field "Annual Hours Saved". I want to create another column with the following logic: If Annual Hours Saved is 0 to 10, then put 1 If Annual Hours Saved is 11 to 20, then put 2 If Annual Hours Saved is 21 to 50, then put 3 If Annual Hours Saved is more than 51, then put 4 Any help would be appreciated!โฆ
-
Countifs Formula Referencing Another Sheet
I could use some help with a formula that references another sheet. The sheet I want to reference is titled:ย Certified Roster Status The sheet has a number of columns.ย But, there are two columns for which I want to use the criteria for the count. Iโd like to get a total count from the column called Status when the wordโฆ
-
COUNTIFS QUESTION
I need to count a contract only if the date when it was reviewed was during Q2 , but the contract can be review several times, so in my database I have a date column for every time I had to reviewed it. So I need a formula that count if revision date 1 its in Q2, but also if revision date 2 its in Q2. Q2 its between :โฆ
-
Traffic Lights for Project Plan
I'm in need of setting up traffic lights (red, yellow and green) for my project plans (x5) Under Schedule Health I would like the following reflected: Any task which is overdue by 4 or more days based on their end date and not 100% completed to be RED Any tasks which is overdue by 3 or less days based on their end date andโฆ
-
INDEX/MATCH for Mirroring Status Column in Another Sheet
Hello! This may not be right formula, but if a user shared a sheet with me which contains a project codes column and a status column (complete/incomplete), and I use the same project codes, can I do a formula which pulls in their status into my sheet? Something like - If (External Referenced Sheet / Column A) matchesโฆ
-
Column header presets
Can I use a filter or a rule to automatically set up my columns in Smart Sheet instead of typing Column headers I want Jan 2022 estimate, Jan 2022 actuals, Jan 2022 variance then in the next three columns I want to add Feb 2022 estimate, Feb 2022 actuals Feb 2022 variance all the way to 2025? I cant copy and paste theโฆ
-
Super Simple: need to reference a date from one cell to another
In my project plan, I am using the Start/Finish as my baseline and then Actual Start/Actual Finish as my actuals. I would like to have a formula for my actual start be the baseline start so all I need do is then put in the Actual Finish. I need a formula to copy the date in the Start column into the Actual Start. For theโฆ
-
"Week Starting" date from created date
Hello Formula Gurus! Do any of you have a formula that will return the "week starting" date based on a created date? So evaluate the created date of a row and bring back the date of Monday that week. Thanks much, Andrea
-
COUNTIF with multiple criterias
I have a formula in my sheet to count the number of unchecked boxes in a column. I'd like to set a condition so that it only counts if the box is unchecked and there is a name in the "facilitator" column (Contact email format). Alternatively, if it's easier, it could count IF there is a date in the automatically generatedโฆ