-
If a date is between 1.01.2020 and 31.12.2020, get the cell checked
Hi everyone, I have a list of documents that have been uploaded throughout different years. I would like to count how many of them have been uploaded in 2020. For this reason, I would like to create a column where the cell will be checked if the column "Date Uploading" is in 2020 and then report it on the Summary Sheet. Is…
-
Sheet Template : When copying a template, my formula's don't migrate.
I'm trying to copy a template to use. I have formulas already on the template, however when i put the new numbers in, it doesn't use the formula to add/subtract them. I have to litterly go through and on every sheet I create from either a template or otherwise, I always have to figure out the formulas again. Is there a way…
-
Work Week Formula
Hello, This may have already been asked however I am not seeing it in the threads, I am looking for a version of this formula =(WEEKNUMBER([Date Entered]@row)-5) to function properly so that it shows the work week (screenshot) : Previously it worked without any issues and showed the 'Work Week', now it is giving me a -4:…
-
Summarize two columns
I'm trying to count the # of instances based on criteria from two columns. I must be missing something from my formula. I'm trying to count the total how many times "SRC" objectives there are that do not have a status of Blue. So, I want it to count statuses with "Red, Green, and yellow" where the business vertical column…
-
Im trying to create a COUNTIF Formula to count Categories based on a particular status.
What I am looking to do is count the Category when it has a particular status. In the end, each category will have three different formulas one for each status. Here is my current formula. =COUNTIFS({VDC Category}, "MEPF Coordination", {VDC Status}, "Not started") The current error is #incorrect ARG
-
Is there a way to log when a new comment has been added?
I am working on a sheet where the comments feature will be heavily used. A whole team of people will be using this and I need the sheet to "log" when a new comment is added. I don't think it matters how. I have contemplated a checkbox column that is checked when added, a date column that I can then use conditional…
-
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…