-
Report Names, Dashboard Titles and Widget Names with non-static strings
The name of reports, dashboards and widgets are limited to static strings, so the user will only know the name of the report and not what information is in the report. Example: The External Appeals Report title cannot be automatically updated to Q1 2022 External Appeals Report. Having automated strings based on the report,…
-
Proofing Download Not Working
Hello, I have a sheet with Proofing enabled. When a proof is sent to a reviewer with the allow download option enabled, the reviewer is unable to download the proof. When download is attempted, a new page opens up with an error message that says, "This link has been removed or cancelled." How can this be fixed? Thanks, Dan
-
IF OR Statement For % of completion
I am trying to write a formula that returns the status of the project based on a column labeled as "% Completion", if the % of completion is 100% then status should say complete. if "% of completion" is 10% then status should be in progress. This is what I have come up with but it's giving me "INCORRECT ARGUMENT"…
-
Link an individual task?
I've tried searching for this and haven't found info - I apologize if it's out there! Is it possible to send a link to an individual task? Sometimes, that's helpful. Since I group all relevant info into individual tasks on the card (e.g., attachments, links, and any conversation), it's sometimes really great to send a link…
-
Quickly Navigate Back to Smartsheet from WorkApps
Hi Community, Did you get tired of having to open a separate browser tab when you wanted to return to Smartsheet from a WorkApp? We sure did, well not anymore! Our latest update allows users to seamlessly navigate from WorkApps back to their work in Smartsheet with just one click by selecting the Smartsheet icon on the…
-
HELP: sending automated notifications to multiple contacts in a cell
Hi Folks Is there a way to send an automated email (via workflow) to multiple comma-separated emails in a cell ? I have tried, but so far have failed. Nothing seems to happen when I trigger the workflow. Any help would be appreciated.
-
Mark Duplicates In Multiselect Dropdown Contacts Column vs Employee Names List?
Ok, we're making a labor schedule, and want to be able to note when and where someone is used multiple times so we can prevent overscheduling someone and ensuring proper manpower. With the above as an example, I want to highlight a cell in [Employees on Job] (multiselect dropdown contacts) column, when one of the values in…
-
Can someone help me figure out why my multiple IF formula will not work?
=IF([PO Type]@row = "Standard With Quote", [Quote Amount (ESTIMATING)]@row - [PO Amount Including Change Orders ]@row),IF([PO Type]@row = "Non Standard No Quote", [Original PO Amount (Labor Only If Req) (PO Admin)]@row)) Everything is fine until I add the second "IF" statement. Thanks in advance.
-
We have this one unlicensed user who cannot "Email Comment"
We have this one unlicensed user who cannot "Email Comment." He has "Edit but cannot share" privilege on a few smartsheets. Tried on another browser, another computer. Deleted account and re-created. No success. We have many other uses that can do it except this user. When I click "Send" button, it tries but no new message…
-
How to avoid webhook triggering from cell format updates???
I'm using make.com to do some automations when certain columns in a row are updated. Works great until someone re-aligns the columns and updates 1500 cells at once, sending my webhook 1500 requests. I can filter them out by detecting the actual data cell history, but it still uses 3000 operations for no reason and ties up…