-
In Smartsheet, how do I lookup and return different values from sheet 1 to Sheet 2 in one cell?
Hello, In Smartsheet, if I want lookup and return different values from sheet 1 (Test-IMS) to Sheet 2 (Test 2-SOS) in one cell, what should I use? Note: The two values from Sheet 1 will be different. Let me know if you have questions or I need to clarify more. Thanks,
-
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
-
Multiple conditions for counting
Super-basic question regarding COUNTIFS. I'm trying to return a value that shows me a count of projects from a certain year, for a certain client. =COUNTIFS((Project Number:Project Number), Contains("2025", @cell ),(Client:Client), Contains("ADV", @cell )) But this comes up as unparseable. Where am I going wrong?
-
Editing Sheet Summary 'CY' Current Year - so my formulas update
I am attempting to enter the CY - Current Year into my sheet summary so I don't have to go through and update every cell formula when creating the new year's metrix sheets. What is the correct syntax in my formula so both CY are pink, indicating it references the CY in the Sheet Summary?
-
Time Zone Changing when forms submitted
Hi, I have created a few workspaces that are grids with the information coming from forms that are submitted every hour. All of my formulas and equations seem to be working correctly but am seeing an issue where the time zone constantly changes back to Pacific time when new forms are submitted (I am on eastern time). My…
-
Finding Next Closest Date of Children
Ok hive mind - I haven't been able to talk this formula out with someone yet, so I am looking for a little help. I have the formula that will fill out the children of my FINAL DATE column, but to fill out the parent row, I want my formula to look at the children of the NON REFUNDABLE DEPOSIT column, and tell me what is the…
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Sending an alert if any one of multiple columns changes after a deadline date
It doesn't appear that Smartsheet has an ISCHANGED function so I am struggling with an alert request. The request is for an alert if any one of 18 different columns has a value change after a deadline date. I guess I could create 18 Record Date automations on 7 different sheets to accomplish this, but that seems like a…
-
What type of formula should I use?
I need to add a specific start and end date dependent on which week # is selected in a "request update" form. For example, if "WK40" from the "WEEK #" column is chosen then "Start Date" would be 9/28/2025 and "End Date" would be 10/02/2025. The problem is that this is for a quarterly report, so there would be 14 weeks with…
-
My dashboard users are unable to view some of the charts, however I am able to view them correctly.
My users of the dashboard are getting the below error for some of the charts, however I am able to see them correctly. Please advise what is the solve for this error.