-
Quoting tool
I am trying to create a quoting tool for our fencing company. I need to add # of products + pricing and have a data field on the quoting form that calculates the total. Example: 50 Ft of fence at $10 = $500. Can i get that to calculate on the form? Trying to create a final quoting page to give customer. how do i do that?
-
=LARGE Formula Question
Alright Smartsheet gurus, I need a hand! I am familiar with the LARGE function and how to use it to identify the highest numerical values in a column. However, what I am trying to accomplish is to feed that data into a dashboard that identifies those values' corresponding categories. For example: Location1 100 Location 2…
-
Date and Time issue - Calendly>Zapier>Smartsheet
can'tHi I have people booking times with my company via calendly>zapier>smartsheet. However, the date and time arriving in the smartsheet cells is appearing as eg 2025-11-25T05:00:00.000000Z. I cant get this to change without it becoming UNPARSABLE. I have tried some standard formulas that AI is suggesting to no avail. Can…
-
TODAY() Function Not Auto-Updating Unless Sheet is Opened and Saved
I’m facing an issue where the TODAY() function in Smartsheet doesn’t refresh automatically each day. It only updates when the sheet is manually opened and saved. The sheet uses TODAY() for date-based calculations, and these values are shown in a dashboard. The dashboard data stays outdated until I open the source sheet —…
-
How to disable popups that obscure my formula?
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
-
Help with Sheet Summary formula
Hi there - I'm wondering if it is possible to join text via a formula in the sheet summary panel if certain criteria are met. For example, if the year is 2025 and the End Date is in the future, and Parent = "Real Estate Budget Items", I'd like to list both the Budget amount ant the End Date separated by a comma. In this…
-
Combining 2 IF(OR( statements
Having trouble getting a successful output with the following formula: =IF(OR([Remodel Design Consultation – Virtual]@row = 1, [Ground-Up Design Consultation - Virtual]@row = 1), "Virtual"), IF(OR([Remodel Design Consultation – In-Person]@row =1, [Ground-Up Design Consultation - In-Person]@row =1), "In-Person", "") When i…
-
Work around for Year transitions when using the WEEKNUMBER formula
Currently, I have a project starting in September 2025 and ending in June 2026. How can I use the WEEKNUMBER formula to create September 29,2025 as week 1 and continue the numbering sequence through June 1, 2026. I also need the formula to flow well when date changes are made to the plan.
-
Stumped with formula generated through AI helper
I recently created a formula using the AI tool, but it's returning #INCORRECT ARGUMENT SET and I can't figure out why. The prompt that I entered was: Count [Project] where [FY26] includes "Yes" or is blank, and where [Project Status] is not "Completed" or "Cancelled" The formula that the tool returned was:…
-
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,