-
How can I add days to dates based on text in another column?
I need to have a specific number of days added to a date that is in Column A, and have it add days to Column C, based on the text that is in Column B. Example: Column A is SC (needs +20) Column B is 7/29/2020 Column C should = 8/18/2020 I have found that (A1,"SC",B1)+20 works per text, but I have 12 different variances of…
-
Auto-assign task to next person on Contact list
I need to auto-assign tasks in a round robin style (i.e. the assignment goes to the next person 'in line' in the contact list). Is there a way to do this with a formula? I understand that tasks can be auto-assigned based on criteria in a specific column but, in this case, the assignment would depend on who was assigned to…
-
Auto Populate Today's Date
When a condition in "Column A" changes to "YES", I want the date in "Column B" to automatically enter today's date. How can I do that. If I use the TODAY function, that cell will update to today's date every day - and I only want the date "Column A" changed to "YES".
-
Identifying specific combinations from a multi-select field
Good morning, fellow Smartsheeters. I have a master roadmap sheet that we use to populate numerous dashboards and reports. One of the columns on this roadmap is Project Type. It is a multi select drop down with the following values: Revenue Opportunity, Revenue Loss Avoidance, Risk Compliance & Cost Savings The…
-
Help w/COUNTIFS and multiple NOT(CONTAINS) functions
Hi team - I created a formula to count the number of numbers of errors in a specific month and does NOT CONTAIN "general counsel" in the Division Requested By column, the June example works: June example formula: =COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Incorrect…
-
IF OR IF Returning two different values based on cell input
I have one cell that can have multiple values. I need a formula to return one value if one set of criteria are met, another value if only one of those values is different. I know it's a syntax issue that I'm not quite understanding correctly. I have the following formula working: =IF(AND(Priority@row = "1 Urgent", [Update…
-
count tasks "on fly" per work week.
Hello Gentlemans , Do someone can give direction on how to count tasks "on fly" per work week. Example; task start 28.07.20 finish 28.08.20, this task will include in count WW31,32,33 and 34 till its finished. task start 10.08.20 finish 20.08.20. ww31 ww32 ww 33 ww34 1 task 2 tasks 2 tasks 1 task
-
How to track late information
Hi, I'm looking to track information that has been received late on some sheets. See below example where date information required was 17th July and we received the info on the 26th July. I am using =IF([Date Information Received]@row > [Date information Required]@row, "Yellow") to turn a symbol yellow if date information…
-
Next Payment Due
Using MIN COLLECT to select from dates the next payment due date. Nothing is being returned. I can't figure out what I am doing wrong. Next step would be to select the value associate with the date. =MIN(COLLECT([Year 1 Due]1, [Year 2 Due]1, [Year 3 Due]1, [Year 4 Due]1, [Year 5 Due]1, [Year 6 Due]1, <TODAY()))
-
Merging data from multiple sheets
Hello I have over 100 smartsheets with the exact same columns and questions. These sheets have been sent out to leadership teams across the country. I need to combine all this data into ONE summary sheet. Is there a way to do that? I do not want to link EACH cell to hundreds of sheets. let me know if there is some magical…