-
Synchronize Column Description, Input Form Help Text, and Dynamic View Description/Help Text
Allow for synchronization/harmonization of Column Description and Help Text fields across Smartsheet assets. The Column Description in Sheet view could be the default source of Help Text for that same Column in any Input Forms based on that Sheet, as well as the Description/Help Text for that Column in any related Dynamic…
-
Top 10 chart based on most entries
Hi everyone - I'm wanting to create a dynamic top 10 list for a few metrics on a sheet. In summary, we have an issues log. I want to be able to chart the top 10 customers with the most complaints added to the log. As well as the top 10 reasons for the compaints, etc…. Similar to what i would do with a pivot table in excel.…
-
My IF Formula only works in certain cells in my grid
I have a formula in my sheet that sums the hours by project, phase and category. Ie for a row with task 1 I get the sum of (1) total hours logged on timesheets, (2) Design Engineer Hours (2) Senior Design Engineer Hours, and (3) Principal Hours. The formulas are as follows: Total Hours: =IF([Budget:]@row > 0, SUMIFS({TS…
-
Unexpected behavior on Form
Hi All, We are experiencing some unexpected behavior using forms that started this morning and is causing absolute chaos in our org. We have been on Smartsheet for about 3 years, and rely heavily on forms for kicking off client projects. Many times the same form will need to be submitted multiple times with small tweaks…
-
Help Article updates May 2025
Hello Community, We’ve published the following new content: Column links overview Create column links Manage column links Dynamic View best practices To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback for each article.
-
Date Added when my Primary Auto Populates?
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…
-
Unable to Access WorkSheet
Last night, everything was functioning perfectly while I was working on a sheet. However, this morning, I'm encountering an error message (Error 48) whenever I try to open the sheet. It's visible in the folder, the error persists on different devices and platforms. If anyone in the community has experienced a similar issue…
-
Help Article updates - April 2025
Hello Community, We’ve published the following new content: Introduction to table view Large-scale sheets in table view Create, share, and apply custom themes to dashboards Admin Center: Understand your security score To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles…
-
Preference sheet
I am trying to make a sheet where a colleague will be able to go through the current job bids, select the ones they want to bid on by preference(1st, 2nd,3rd ect…). If they only a few jobs they want to bid on i have made this however, if there are 20+ jobs, how can i create sheet that can accommodate this. I don't want 20+…
-
Can someone please help with this formula?
I keep getting an "invalid operation" error message with this formula. Can someone spot where I went wrong? I am not great at formulas. The goal is for multiple criteria (IF statements) to match before entering "Inactive" in the cell. =IF({Master Cadre Roster Range 1} = [First Name]@row, IF({Master Cadre Roster Range 3} =…