-
When will Smartsheet be back with full functionality?
Hi! We have serious issues with Smartsheet. I can't add new rows with forms, automation / workflows doesn't work, notifications are not sent. For us it a total chaos as every job goes through smartsheet and now more than 20 people can't work. Please help. Thank you, Norbert
-
IF OR Statement For % of completion
I am trying to write a formula that returns the status of the project based on a column labeled as "% Completion", if the % of completion is 100% then status should say complete. if "% of completion" is 10% then status should be in progress. This is what I have come up with but it's giving me "INCORRECT ARGUMENT"…
-
Reminder based on Hour
Hi there ; İ would like to ask that how can i set a workflow based on hourly as below example : send a message to a contact person , if this checkbox is not checked and if the time passed 10:00 am.Everyday check this issue and send message imagine that message i have already , there is contact person , there is one…
-
How do I copy a row between workspaces?
I have two workspaces: 1) department-wide 2) my workspace. The owner of 1)department-wide is my supervisor. I am an admin in this workspace. My supervisor does not have access to my workspace (#2). I want to run a workflow that copies a row from a sheet in workspace #1 (department-wide) to a sheet in my workspace (#2).…
-
DataShuttle Error: Access Token is Invalid
Hi, I have a datashuttle that's been working for several weeks but today gave the error: Workflow Execute: Your Access Token is Invalid. I didn't use any API to create this datashuttle, and we don't have JIRA connected.
-
Workflow Not Working
I have a workflow to copy rows to another sheet if a checkbox is checked (the checkbox column has a formula in it to make it checked depending on another cell). Please see the attached images for what the setup looks like. The rows are all pre-populated due to formulas required in each to calculate out information. That's…
-
Managing Change Requests on existing portfolio of projects
Situation: about 85 projects in a portfolio. As PMO, want a simple tool for project managers to submit change requests for major changes to their projects, principally to request a change to end date and provide a rationale for why the date needs to change. Ideally, a link from the project plan that allows a form pop-up to…
-
Populate multiple metric sheets with cross-sheet formula(s)
I'm looking to improve how I've set up several metric sheets to make sure data is staying up-to-date. The components of the workflow are here: Sheet 1 = This is the reference sheet that is used in reporting. Our billing department uses it to track claims. It's a basic sheet with a simple automation that moves rows to an…
-
Anyway we can automate SmartSheet to remove / delete rows.
I have a dump sheet that needs to be clear every day. Move row does not work, its adds another step into a simple task.
-
Alerts Not Working
Hi, We have created an Assigned To field (Contact List property) and set up a workflow to alert the person in the assigned to field when rows are added. The alerts are not working though when we submit a test request. Is there something that we should be doing differently? Thanks, Ara