-
Copy Row Not Working
I'm on one of my sheets this morning and right-clicking the row and selecting Copy Row to another sheet. I select the sheet and hit OK. It's not going to the other sheet. I've tried 5 times and closed the browser and reopened it. Is anyone else unable to get Copy Row to another sheet to work today? Not the automation...the…
-
Email automation
Hi, I have a form where users insert an email address, then an automatization sends an email to this addres, but if someone inserts wrong the email in the form (for example, one letter is missed) , how can I detect it? How do I know the mail has not been delivered? thanks in advance sandra
-
Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row? An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.) Can I build something so she can create a row per patient with their ID…
-
Drag and Drop from Smartsheet to Google Drive?
Is there a way (or an add in) to drag photos directly from Smartsheet to Google Drive I know I can drag from Whatsapp to Drive but I need to do the same from Smartsheet to avoid mucking up my laptop with downloads.
-
disappearing sheet in workspace
Hi community! I am working in a workspace shared with one other person, which contains a folder of reports and a dashboard only she and I see, as well as the underlying sheet that's owned by a different person and shared to a group of people. The sheet keeps disappearing from the workspace on and off. Not only that, but my…
-
"Available to anyone with the link" is not showing
Hello Community, I am trying to publish a report so we can let customers view it, but the "available to anyone with the link" is not populating. I am a system admin and this is a first. Please let me know what I can do to fix it. Thank you
-
How to add another sheet reference into IF formula...
Hi! I just want to add another sheet reference into the below IF formula... It might need an AND statement, but I could not find a solution for it. =IF(CONTAINS(Number@row, {Sessions 1 Range 1}), "True", "False") Any ideas?
-
How to create a dashboard chart showing the actuals (completed) vs planned (not completed) tasks?
How to create a chart in a dashboard having two lines showing the actual number of finished tasks (completed) vs the planned number of not completed tasks (Not started, In Progress) on a timeline? Any help would be much appreciated.
-
Is an automated export of a Smartsheet to an Excel file possible?
Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an automation that will email me an Excel copy of my project plans on a weekly basis (or when triggered with a change - I don't really care) as I…
-
How to spread costs evenly across months, if they fall within those dates
I have various financial line items that span different dates. I'd like the costs to be spread per month automatically based on the date and cost entry. I've tried various functions already, IF, AND, and it says Unpearsable. I'd like to spread out the costs in the Cost column to the months on the right, based on the start…
