-
Formula not Calculating the Correct Number
Hello, I have a formula that counts notifications that are tracked on another smartsheet each month. The formula is: =COUNTIFS({Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row , {Impacted Department}, <>"XX") The results from this formula are no longer calculating correctly. For…
-
Requesting Status
I am an owner and an admin. Why can i not request status?
-
Creating a summary for a workspace
I have a workspace that has a revolving set of sheets. Some of the sheets are active for the time being but are not active now. There are several cells that I would like to have on the summary , like the client name, the status of the sheet, the date expected to go live, health of the sheet. What would be the best tool to…
-
Need to retrieve the complete driver payroll sheet
I am unable to retrieve the complete driver list and would like assistance in recovering last Friday’s data
-
Getting errors trying to transfer ownership of a sheet
We have MANY sheets to transfer. This is as a result of our company domain changed (hii-tsd.com to hii.com). So we transferred ownership to 3 people (myself included) on the Portal Team, who manage the Smartsheet files. I had a co-worker on the portal ACCEPT the email that was sent to the shared mailbox, and then the…
-
Automation to Combine Multiple Row Attachments into a Single PDF
I’d love to see a feature or automation added to Smartsheet that allows users to automatically combine multiple PDF attachments into a single PDF. Use Case: I have a Smartsheet where we collect applications, and each application includes several supporting documents uploaded as individual row-level PDF attachments. When…
-
Enhancement Request: Allow changes to Column Type when Conditional Formatting is set
If a column is associated with any Conditional Formatting, the column type can not be changed. This is true even if the Conditional Formatting Rule is disabled. This is true even when changing Column Type from 'like' types, for example Text/Number to Dropdown List. This is an inconvenience, minor at best, severe at worst…
-
Restoring from Sheet Snapshot when auto-generated numbers are involved
I recently inadvertently deleted a large amount of data from a sheet that has an auto-generated number column. While I know how to restore from a backup, I have no idea how to restore the originally assigned auto-generated numbers without completely messing up the sheet. Has anyone come up with a creative solution to…
-
Doing a mass update of sheet reference names
I have been waiting for find/replace within formulas, but wondering if there is a different way to solve my problem. I have raw data in quarterly sheets that feed an annual sheet where the data is broken out monthly for the whole year. Every year I create a new annual sheet and have to update the formulas with the…
-
Multiple Licenses from different company
Hello, Im working as a consultant/developer. Im signing up with multiple clients each with their own licenses. They are adding me as I work on their project. May I know if this is possible? Will they adding me have an issue on file/sheet/workspaces view and sharing? Any tips to avoid mixing up stuff? May I know if there…