-
Sumifs with text and numbers
I have this issue I am using a nested if-statement as a column formula where two of the values are sometimes text and other times saved as values. These are budget numbers so one example is 23001 & 23001F which are two different funds. I have tried both with and without CONTAINS, but the row for 23001 is either grabbing…
-
I am needing help with a formula that includes multiple dates and criteria.
I'm needing help with a formula I can use to verify the last submitted entry "Created Date" that matches my "Identifier" and Projected End Date is not blank, I want to collect the "Projected End Date" or if the Projected End Date is blank on the last entry I want to collect the "Class End Date" for that "Identifier". Here…
-
Setup of summary sheet to graph for dashboard
I currently have a master sheet where we gather weekly data. You can see in the photo that I have helper columns for year and week. These entries are individuals. The other important columns are the Pack name and total columns. Master sheet What i need to do is to create a summary sheet that will total the points by "Pack"…
-
Approval Workflow Not Triggering
I'm trying to set up an approval workflow when a submitter doesn't give a 90-day notice for a meeting request on Smartsheet. Every way I set it up, it won't trigger!! I require a 90-day advance notice to approve a meeting. When a request comes in on Smartsheet, I need to set up an approval request automation for this as it…
-
Help combining: IF INDEX MATCH
Hi, Please help me with my formula, I'm trying to GET a Contact Column, based on matching criteria, (The columns referenced are from a separate sheet.) I tried using: =IF({Sheet 1 Range Status Column}, "Approved", INDEX({Sheet 1 Range Contact Column}, MATCH(HAS(@cell, Reason@row), {Sheet 1 Range Reason Column}, 0))) It's…
-
Smartsheet Gov - Dropdown information dictated by Previous Dropdown Information Selected
I am just wondering if it is possible to set up a sheet where there are three columns that display information that is dependent on the information selected in another column. In other words, the user will select information from the first column, and it will filter the information shown in the second column. The…
-
I am trying to create a formula with Symbols based on date, today, and range
I am wanting to build a formula with the following features. Blue= tentative discharge date (date inputted in cell) Green = tentative discharge 7 days from today Yellow = tentative discharge date of 8 – 14 days from today Red = tentative discharge date of 15 days or more from today This is what I have proposed, but not…
-
Is it possible to set a formula to subtract the next row that meets a specified criteria?
I want it to look for the name john and subtract the last number John entered from his most recent entry. My form is set up to have the entries come in at the top of the sheet. Any ideas on a formula to use?
-
date related formula
Hi I am trying to create a formula to show the number of units due in the next period of time e.g. 7 days, 14 days, 21 days etc. I have a due date column and a Units column. I actually have several unit columns, but if I can get help with the formula for one, I can easily create the others. Kind Regards Peter
-
T Minus Weekly View - Formula or Automation?
Hi team, how do I create a formula or automate a t minus weekly view. For example if start date - finish dates are within these parameters: 10/31/22 - 11/05/22 then I would like the T minus column to show 29. 11/07/22 - 11/12/22 to show 28 in the T minus column. How can I set that up in Smartsheet? Thank you for all your…