-
=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…
-
Dynamic Dropdown Lists Driven by Formulas
Hi all, Is it possible to dynamically populate dropdown lists in Smartsheet based on the contents of another column or sheet (like dependent dropdowns in Excel)? If not natively, are there creative formula-based or automation workarounds users have found effective for keeping list options up to date as data changes?…
-
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…
-
Ideas/workarounds for how to look up multiple values into multiple rows?
Hi Smartsheet Wizards. Bear with me, as I'm not sure about the best way to ask this question…! I have a "look up" sheet with thousands of contacts/email addresses and organization ID numbers. I need to pull out all of the contacts for a specific set of organization ID numbers. I have this set of ID numbers in another…
-
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:…