Using Smartsheet
Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.
Discussion List
-
IFERROR not workingIn Using SmartsheetI've created an intake column to count the # of days based on a date in the Approval Request Submitted column. I want to use IFERROR to remove the INVALID DATA error and replace it with a "0" (zero). my attempts were; =IFERROR(…
-
Blank Destination Sheet when trying to build Copy Rows WFIn Using SmartsheetHello Smartsheet gurus, I am attempting to build out a workflow that automatically copies rows over from a source sheet I have Admin access to, to a destination sheet. My problem is, every time I try to select a destination sheet, the sele…
-
Power Automate SmartsheetIn Using SmartsheetHi, I am trying to insert a new row based on a trigger that when a new row is created to a sheet. I have used Zapier a lot in past to setup these tasks but Power Automate is way to complicated. I am unable to map column name from trigge…
-
How to get Row ID or Original ID in SmartsheetIn Using SmartsheetI need this for an integration with Zapier. Can anyone tell me how to get this number for all rows in a sheet? Note - Row ID is not Row Number. It should look like this: 5418114689066884 Thank you!
-
Multi checkbox with logic to dropdown fieldsIn Using SmartsheetI'm creating a form for job recruitment. What I'd like to be able to do is have a multi-select checkbox with logic that only opens an additional field for the checked items (pic below). I set up a Logic for each individual field, but when …
-
User PermissionsIn Using SmartsheetHi I have set up a Workspace called TDR under which I have the PMO template. We have numerous Project Managers and I want to allow them to create new Project Level, project folders, from the Template folder. What access do I need to give…
-
Need way to add a counter on a dashboard for user "views" or visitsIn Using SmartsheetHi everyone. Absolute beginner here. I'm tasked to make a few dashboards for other internal company teams on project progress, etc. We want to track how often people visit each dashboard and thought it might be useful to include that as a …
-
Is there a way to show the history of a cell in another column on the corresponding row?In Using SmartsheetI have a due date column on my smartsheet, but would also like a column that shows the cell history of that due date so it is visible on the sheet without having to click on cell history each time. Is there a way to automatically populate …
-
How to view and use the Modified and Created fields in SmartsheetIn Using SmartsheetIs there a way to capture the Modified By and Created fields in a sheet or report? I'd like to be able to create filters based on the current user in a sheet. Situation: Multiple users giving input on one Sheet. Issue: Concerns with dat…
-
Availability ViewsIn Using SmartsheetI would like to show team members availability - *available days *vacation days *sickdays for complete year ,, Is there any template to achieve this or can anyone please help me how to proceed with this. For Example: Something like this
