-
Send row data but only for columns with data
I have a sheet that has 400 columns. When I am done with the client I would like to send all the data I collected to a team. However if I only got 100 of the 400 fields filled out, I'd like to only send those 100, and the next time send maybe 200 etc... Can we send row data via email, but ONLY if the column is filled in…
-
Conditional Formatting to Changed cells
Is there a conditional formatting formula I can create to only highlight certain cells that have changed? For this conditional format I do not want to use Highlight changes and see the whole sheet changes. I just want a certain column/cell to be highlighted and notification sent if a change is made.
-
What is the best way to copy Workspaces
Hi everyone, I am looking to create copies of some of my Workspaces and am facing 2 different issues. The 1st issue is I have a large interconnected Workspace with over 200 items inside it. I need an exact copy and don't want to relink everything as I would need to do this multiple times and would be days of work. The 2nd…
-
Approve / Decline Comment Option
I have a created an approval request in a workflow and am unable to see how to add the option for the approver/decliner to enter a comment when approving/declining?
-
Duplicate Automation Email
Hi all. I am trying to notify a coworker when a customer has multiple entries on our sheet. I currently have it set up so they are notified, but it only includes the new line that was added showing it was flagged as a duplicate. Is there a way to have the email show both rows in the email notification?
-
Form multi-line text box issue
Hello, When someone fills the form with multiline text, they can put space and a new line however, the way you receive it is one combined text. Any workaround to fix this? e.g., in the form, you can type xxx yyy zzz the way you receive it is xxx yyy zzz Thanks,
-
How to deactivate Hyperlink in Automation alert?
Hello, I want to use the alert/email format that usually comes if you select one of the first two options. However, I don't the link to be hyperlinked/clickable as I don't want to provide sheet access to the users. The message-only option alert is not helpful as it's all text.
-
Outsourcing Smartsheet
Hi all - our staff member who handled all Smartsheet content has left the organization. I only have time to learn some of what is needed for the 2023 dashboard and integration needs. I am looking for assistance quickly and am willing to outsource these two projects. Would anyone have referrals to share? Thanks!
-
Maximum Number of Automation Workflows?
I scrolled though here and can't find something to job my memory. I think I had learned it was 50--is that correct? Would be awesome to have a Capacity Quick Reference sometwhere in the Community or Help page. I would bookmark it or print it out to save searching and asking. :) Thanks!
-
Grouping limit in reports? Data cut off, not collapsed.
Hi there, I know there are some limitations with grouping in reports, but I don't think I've run up against them just yet. I have a report with 2,059 rows but when I group them, the report only shows 1,974 rows. I tried removing some columns to reduce the overall number of cells, but that didn't help. I don't see any…
