-
Licensed user no longer creates new Smartsheets and now only edits, can they now be a free user?
If a licensed user had created a Smartsheet but no longer creates new Smartsheets and now only edits their existing Smartsheet, does that person still need a license? Or can we reallocate their license to someone else if all they will be doing going forward is editing an existing Smartsheet that they already created?
-
IF AND Formula with Multiple Criteria and return Text Value
I have a percentage completion column, status column, and finish date column. I would like a formula as follows to enter a text value into the status column… IF percentage = 100 and Finish date = Today then enter "Complete" if true and "In Progress" if not. If percentage > 100 and Finish date > Today then enter "Not…
-
Resource Manager Advanced Reporting Schedule
Would like the ability to edit the Advanced Reporting schedule in RM other than just from manual to automated. We need the ability to adjust the run schedule to different days and times and specify Time zone. The only current way to do that is to create an entirely new Advanced report at the exact time you want it to run…
-
Print report - Summary Totals not showing on PDF
Hello. I have several reports with Summary fields defined within the Report file. My question is, why aren't the Summary fields showing up on the printout / PDF version of the report. I see the Summary fields on the Report file, but they never seem to show up once I select the Report to print. Suggestions? Thank you!…
-
Share Data Mesh Configs with other Admins
I would love to be able to allow other Admins to see/edit my Data Mesh configs.
-
Timeline view in Dashboard
Please enable the Timeline view in Report and Dashboard. This is a better way to present timelines in a dashboard vs Gantt charts.
-
Automated Notification - Force Cell Reference Values to Wrap Text
Is there a way to make a cell reference in an automated notification show as wrapped text? I am trying to get the cell reference in the automated notification to show each selection on its own line. As shown in SmartSheet with Wrap Text on column. As shown in the Automated Notification cell reference.
-
Control Center - Blueprint Permission setting for "Commenter"
We are able to set the sheet level permission "Commenter" for specific blueprint template, but we'd also like to be able to set up "Commenter" permission to certain User Group in Blueprint setting > Permission > Advanced. However, I only see these choices and no Commenter. Can you please add this choice so we don't have to…
-
How can I automate sending emails to a given cell upon changes to a row?
Hi. I am using an Automation workflow template for Alerting someone given a change in a row. I would like to send an email to a given email address in an 'Email' column in my sheet if something in the row changes. I see only the options to send a email to a given contact in the sheet or to prespecfied people, however these…
-
max(startdate) function in Countifs.
Hi all, I am looking if someone cane help me in writing an expression, I am creating a calculation sheet in my smart sheet, I have a multiple teams (5 separate sheets) sheets with Project name, description, effort points, Status(dev, test, uat, done) weekstartdate and weekenddate In my calculation sheet, I have columns…
