-
Need another pair of eyes - Know there is an easier way
I have 2 sheets (soon to be 3) where I am pulling metrics from 25+ different sheets to get monthly data. It is working, but every month I have to manually edits every row (over 300) to add the next month of data. So I would love some ideas on how to make this easier and less manual. Here is an example of my sheet and…
-
Record Date workflow is not working if trigger is more than 2 level of trigger,
Dear Team, Is there any limitation about trigger clause "When", I have scenario which has 8 level of approval. once it's approved i am capturing date as approved data for each approval. kindly check screen shot of approval trigger. Need your advise for below. based on condition i am capturing date. Is it correct way ?…
-
Expression using the "Created Date" field
I am trying to have a column default to a specific dropdown option in a grid/sheet if the "created date" = Today. Is there a way to use this?
-
find number of days per month between 2 dates
Hello, i need help with the below I have many projects with cost that i need to divide: here is one line. start Date 02/10/2022 end date 05/06/2022 cost : $35,000 Looking to project the average cost between those 2 dates per month. solution: 86 days between start and end date 19 days in February x $406.97 ($35000/86)=…
-
Average number of day formula
I have these two columns "Date Created" and "Date Closed". I need to write a formula that looks at all 1000+ rows of data and produces an average amount of days it takes to close a row of data. The formula will be in my calculations sheet. So, I'll be referencing this data. Should I use the "averageifs"? I really…
-
Formula to display Planned Progress % in reference to Actual Progress %
For the Actual Progress %, we are using this formula to surface the latest number: =MAX([Actual Progress %]:[Actual Progress %]) However for the Planned Progress %, I use the following formula and it is showing no match: =INDEX([Planned Progress %]:[Planned Progress %], MATCH(MAX([Actual Progress %]:[Actual Progress %]),…
-
Countifs Date Formula
Hi there, I need to create a formula that counts how many dates are less than or equal to the project's completed date. I have this formula so far, however when I try to add on an "=" with another "Countifs" or "Or" my formula does not function. =COUNTIFS([Expected Go Live Date]@row, >[Completed Date]@row) How can I add on…
-
Trouble getting multiple IF statements to return a value
I have been able to have one IF statement return one value but when i try to add multiples i receive #unpareseable. Can someone tell me what i'm doing wrong? Trying to have a "Cognitive" value return "Sport Gait "1" "Gait" value return "Sport Gait 2" "Both" value return "Sport Gait 1&2" =IF([Why did they not pass?]@row=…
-
Calculate the number of months between two dates
I am relatively novice in Smartsheet formulas, but decent in Excel... I cannot find a way to simply calculate the number of months between two dates, for me then to multiply the count of months by a $ value. For instance: So I would like to just assume all months are equal in 30 days, so difference between 1/1/2020 and…
-
Using COUNTIFS with OR function spread across multiple ranges
Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges. Example: In Sheet1, I have the following columns: shape, color1, and color2. In Sheet 2, I would like to create a function which counts all observations in Sheet1…