-
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
-
Copy an automation from one sheet to another
I make different types of sheets that require the same automations, so instead of copying the sheet, it would be a big time saver to copy automations instead recreating them.
-
Sheet Automation Workflow: Can you set a Run workflow cadence to Bi-Weekly or Monthly?
Is it possible to have a workflow run Bi weekly, Monthly, etc? Only options I see are "When Triggered", "Hourly", "Daily", and "Weekly". Thanks for the support if any functionality exists already. If not a function. SMARTSHEET can you make this a reality?
-
Is it possible to send emails to form submitters?
I have a public facing form and was looking to provide an automated response to the form submitter, but the submitter is not part of our organization/part of contact list. I would like to use the e-mail address they provide to send an answer. Hopefully with the document attachment that is created automatically through…
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.
-
Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
-
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
-
How can I set up recurring tasks in Smartsheet?
I need tasks that repeat (daily, weekly, monthly, yearly). Each should show a due date and a “Completed” checkbox. When I check it off, I’d like the task to log in an archive sheet with the completed date and then reset on the main sheet with a new due date and cleared checkbox. Has anyone found a simple way to do this?
-
Is there a way to sort reports when sending them as an attachment?
Sharing a report weekly with users, the report send sorted by the first column regardless of the sort in the UI version of the report. Is there a way to ensure the report sends with the sort from the UI?
-
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…