-
Need Formula Help
Hi Dear Community ; I am new about smartsheet so i would like to get your kind supports i need a formula like that ; i have a sheet as below with column names , in my scenerio i am getting datas with forms from last users , for example when the last user choosed the "Status" Column as "completed" , i want that the date of…
-
Latest Date in a column
I have set up an automation to set the last updated date in a column on a project plan. I want a formula that will reference the project plan last updated column to show the last date the project plan was updated. I am using the following formula: =MAX({Project Plan Range 1}:{Project Plan Range 1}) I'm getting a…
-
Static Date/Time Stamp
I've looked around and I realize that this is a feature many people want within smartsheet. I was wondering if anyone has a workaround for this. I want to automate the start date to today but I don't want it to change so using =TODAY () won't work. The sheet that I'm trying to implement this in also uses a form to input…
-
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…