-
Trying to use SUMIF to add columns a crossed a row
Below is the formula I am using =SUMIF([Committed Or Projected]@row:[Committed Or Projected]@row, "Projected", [Jan-23]@row:[Dec-23]@row) The error message I am getting is #incorrect Argument set. I am basically trying to add a row range if a value is set in another column. Can Sumif only be used on columns,s not Rows?
-
Formula for [date]+1 month?
Hi all, If I was using excel, I'd use: '=DATE(YEAR($A1),MONTH($A1)+1,DAY($A1)) However the equivalent smartsheet formula... '=DATE(YEAR([Column2]12), MONTH([Column2]12) + 1, DAY([Column2]12)) ...doesn't seem to be very "smart" at all, because it gets to December and can't handle the concept of rolling over into the next…
-
Cross sheet formula, check the box in one sheet when ALL boxes are checked in another.
I have a three sheet cascade of check boxes that have cross sheet formulas. Mother Plant sheet Mother Segment sheet Mother Batch sheet There are multiple Plants per Segment; multiple Segments per Batch. I "Retire" plants as necessary, sometimes all at once and sometimes at different times. I want the "Retire" check box to…
-
Formula to calculate 1 month from given date
Hello, I am trying to count one month from a particular date and need help with the formula. for example the move in date is 7/29/2022 I want Smartsheet to automatically count 1 month from that date as the due date in a separate column? how do i go about doing that?
-
Using INDEX(COLLECT()) or VLOOKUP
I have a data base that has part numbers listed multiple times based on production date. I am trying to gather the status (RED, GREEN, YELLOW) symbol from another column but I want to make sure it is from the most recent addition to the data base. New data is added via form to the top of the DB. I believe VLOOKUP will…
-
If Comment is not blank, then show the recent comment and date
Hi everyone, I have a Follow Up Date column and a Comments column. I have predetermined dates under the Follow Up column. I would like a formula to populate the most recent Follow Up Date and the corresponding Comments on the parent rows only if the Comments are not blank. Any help is appreciated! Thank you!
-
RAG Status by Percentage Complete and today's date
Hi Query I have a formula for RAG status which I've been using to manage performance across multiple projects looking at the columns end date, % complete, and referencing today's date. However it is not working as planned and wanted to ask for some help please. I would like the formula to simply change the RAG status for a…
-
Easy way to express Monthly Data
Hi all, I have started a project to use Smartsheet to track Right First Time across several departments. As part of this I want to track the data on a monthly basis. The form uses a 'Created date' field to input the date when the entry was submitted. Is there a way of expressing the date, so I can use it as a COUNTIFS…
-
Nested If statemens
I've read various posts on the forum and have been able to fix a few of my issues but I can't seem to get past this one. To show the stage of a project is in a workflow, I am using various IF(AND(NOT(ISBLANK, meaning that stage has been completed. So, if the Outreach stage is complete, it will not be blank, etc. In my AND…
-
formula running the status column
This is the formula in status. The issue is that if the date is TODAY either in START or in END Date column the status turns to NOT STARTED. I need the status NOT STARTED only to show up when the start date is in the future =IF(Level@row <> 0, IF(Level@row <> 1, IF([End Date]@row = "", "", IF([Canceled?]@row = true,…
