-
Nested COUNTIFs within Date Ranges
Hi Smartsheet Experts, I need some help creating a formula. The Source sheet contains the data and I have formulas on another sheet; therefore, the formula will contain cross-sheet references. Source Sheet looks something like this: I want to count the number of Items that have an ORIGINAL or NEW date in January 2021 but…
-
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…