-
Requesting Updates to Report
We have a spreadsheet with data that needs to be updated/validated twice a year. We wanted to use a workflow, but some owners/approvers of the data have 150 rows to their name. We don't want to flood their email with that many emails or have to go through 150 lines that way. We are working with the idea of sending an…
-
How to best import a Smartsheet backup with attachments
One of our employees accidentally deleted a lot of information and attachments from a sheet. We pulled the most recent backup and imported it to replace the missing data. What we found was that while it pulled in all of the rows, attachments are all in a separate folder with random names so it is impossible to tell what is…
-
When will increase in cell limits be implemented?
I attended last year's Smartsheet Engage and there was a big announcement that Smartsheet would be increasing cell maximums in sheets - from 500,000 to 5 million. Any more word on that? When will these new cell limits be implemented? I have several big projects I'm holding off on until the increase happens.
-
Document generator - Font/Data error
The smart sheet document generator is showing erratic values; it used to work fine previously; however, any new document generated now creates an error; if I type ABCD in the smart sheet cell and then generate through the document generator, it will show something like (e^pp^k or olp^ifb) instead of ABCD as desired. Any…
-
Link to local files or folders on company drive
Dear all, obviously this has been an issue since a couple of years for a number of people. I could not find a solution, yet. I want to link a cell in Smartsheet to files on our companies drive - meaning: If I click cell@ a certain folder or file on my local drive should open. How is this possible? So far I can only add a…
-
Workflow automation does not work by default it works only when it triggered manually
Hello, I have a workflow that trigger when a new rows are added, the rows will be added by a form. When the form is submitted, the workflow will search for the rows that is checked and move it to another sheet. However, this does not work until I manually press run. UPDATE: It worked now!!
-
PSA: Conditional Formatting Stopped Working
I went through hell trying to figure out what is causing my conditional formatting to suddenly stop working when it was working perfectly in the past. My sheet is shared by 104 people. After many hours scratching my head and calling support we figured out the issue. SOMEONE TURNED ON HIGHLIGHT CHANGES and made the…
-
Bi-directional update between 2 sheets without report?
Hi, is there any workaround that allows for bi-directional updates between two sheets without the use of a report? For example, Sheet 1 has Unique ID and Status columns, same goes for Sheet 2. What I want to be able to do is if either the Status column gets updated for a project in Sheet 1 or Sheet 2, the information will…
-
Add Multiple Conditions to Conditional Formatting
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
-
Workflow "Customized Message" not displaying in Alert
I have a workflow triggered by date (daily at 5pm) that has a "customized message" set up. However, the customized message is not displaying in the resulting alert, which simply states "Reminder: Name of Sheet." Attached are screenshots of my workflow setup, along with the resulting message in Slack...