-
Duration formula
I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates. As such, somewhere I have lost the duration formula in that column. Can someone please help me with the formula that would determine the work days for planned start and planned finish minus weekends? Thank…
-
Keeping Track of Completion Dates and Updating Status
I am relatively new to using Smartsheet, but here is what I'd like to be able to do. I have a Course Development Tracker sheet that lists courses to be developed in the next term. My team has a 60 day development process, with 5 checkpoints. Each checkpoint should be met by a certain number of days from the due date. CP#1:…
-
Auto inputting a date based on a status change
Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. Is there a function to do that? Regards Mike
-
IF formula with date range that defines a set time period
Statement to solve for - If FINISH date is between x and y dates, the it = 30-60 (time period in a drop down) Formula created, but not working =IF(Finish)42 >=DATE(2020, 12, 21) OR <=DATE(2020, 12, 25), "30-60") Can anyone help solve for this so that I can automated setting a time period based on the task date?
-
Return a number count based on criteria within two separate columns
I'm seeking a formula that will return a value if a certain criteria is met in one column and another criteria in another column. For example, I'm trying to count how many items there are that have "Medium (within next FY to 3 yrs)" with a status of "Green". I'm trying to report this in Sheet Summary. Thank you!
-
IF statement that sets a drop down symbol
Looking to utilize Harvey balls so when a % Complete is within a range (see below) it defines the proper Harvey ball. I am able to accomplish the formula using 2 variables but unclear how to set for a range? FORMULA =IF([% Complete]1 >= 0.9, "Green", IF([% Complete]1 <= 0.8, "Red") Example Ranges for Harvey Ball. G 90-100…
-
Can you use an If...Then Formula to populate multiple columns?
Hi! I am looking to create a formula that will auto populate three columns depending on what region is chosen. For Example: If the region chosen is the Northeast then I want Person 1, 2 & 3 to auto populate. If the region chosen is the Mid-Atlantic then I want Person 1, 4 & 5 to populate...and so on. Is this possible? I…
-
SumIf if cell is a number
Hello! I am trying to create a formula that calculates the sum of the following columns: Column1,Column2, and Column3. These single select dropdown columns are restricted to the options N\A & numbers 0-10. I need to create a formula that omits the option N\A and sums the other columns. Thanks!
-
Count criteria in multi-select dropdown
Is there an edit (or alternate formula) to the 'COUNTIFS' formula I'm using to count all instances of a particular criteria whether or not its included in a dropdown list on its own or listed among other criteria? As an example, the formula currently show is only counting instances of "SRC" when it's the only criteria in…
-
Imported Formulas from Excel
Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it- hoping a fresh set of eyes can help me pick out the culprit. Thank you!…