-
Help with Formula!
Hello, I'm pretty new to smartsheet but slowly working out how to create some functioning formulas! I wonder if anybody might be able to help me with the latest one please? I have multiple columns containing different data types (some are tick boxes, others are dates and some will say 'N/A' - I am trying to write a formula…
-
Notifications using Summary Sheet
If I create an automation workflow to notify all contacts on a sheet, will those listed in the sheet summary be included?
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
-
Creating Alert to Notify Users Once Agreement Signed
Hello, I am trying to create an alert that would notify users once an agreement has been signed. I have watched some Smartsheet videos but I'm still a bit confused on how to create one. Why might the “Automation” button not appear near to “File” button even though I am the Smartsheet owner? See the attachment.
-
Ultipro to Smartsheet
I'm pretty new to Smartsheet and trying to figure out a new workflow. Currently all new job postings and job applications are captured in Ultipro. There is currently no integration between Ultipro and Smartsheet, what would my options be to move candidate data from Ultipro to Smartsheet so I can start building a candidate…
-
Meeting Agendas - Are you utilizing Smartsheet's Meeting Management Template Set?
Hello, I am relatively new to Smartsheet and am interested in hearing how folks are utilizing Smartsheet’s Meeting Management template set. My organization is looking at potentially using the meeting management template for our meeting agendas and minutes but are running into a few snags. We are considering using the…
-
Publish with Filter ON
I have a card view that is set to display with a filter on by default. Is it possible to also Publish this to the Web with a filter on by default?
-
Edit Interaction - When this widget is clicked on
Hello, I see that I can go back to the spreadsheet where the original data is when I click on any "part" of the chart (pie on screenshot). However, I'd like to click on a specific piece of the pie "complete, in progress, on hold, discarded" and be sent to just the filtered rule I have set up for each state of the items, so…
-
Automated Workflow - Invalid Date Error
I have set up an automated workflow to trigger when status changes to complete if date field is greater than 12/31/18. I am able to choose the date but it changes to "Invalid date" when i save the workflow. I thought maybe since the date field i was using is an automatic number field, it didn't recognize the field as a…
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the…