-
Using IFERROR Formula - Still getting UNPARSEABLE error
I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row / [Column2]@row --> This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an "UNPARSEABLE" error. I want the cell to…
-
Dynamic View not allowing editable field
Hi, I have 2 fields in my Dynamic View that are built exactly the same way. One is showing as Read Only and the other Required. They both need to be Required. Anyone else having this issue? I just built this last week and was working correctly until today.
-
Manufacturing Production Report
Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning. We created a form in Smartsheet for the production managers to enter…
-
Bridge Workflow - Runs with no Errors but doesn't copy data to column. Am I missing modules?
I have a Bridge Workflow that is set up to copy data from a row/column to the same row/different column. The workflow runs with all module steps "SUCCEDED". However, the end result is not copied in my Smartsheet's target column. Its blank. Am I missing a module or module steps to complete the copy routine? -- Here's a…
-
Need to update a field in Document Builder that uses Docusign
Hello, I inherited a sheet that uses document builder and docusign to generate a letter that has to be signed by multiple people. I understand that in the template editor the fields that in blue refer to columns in the generating sheet. However, I need to edit the options for a field that is not in blue, and I cannot…
-
How to add project dashboard link to project metadata sheet when using PMO template
Need some help here. Set up the PMO using the PMO template. PMs have added projects but the project dashboard hyperlink never populated in the intake sheet nor the project metadata. Trying to add that in now, as the project plan is already created. I've tried to hyperlink the project dashboard URL, copy/past the URL in the…
-
Power Automate & Smartsheet: Requires 'String' But Is 'Float'
Has anyone who uses Power Automate with Smartsheet run into this issue before? I'm trying to set up a flow where when a sheet is updated, a row in SQL Server is updated. The error I'm getting is: "ResponseSwaggerSchemaValidationFailure. The API 'smartsheet' returned an invalid response for workflow operation…
-
Data Mesh Run Immediately
I saw a post from 2019 stating that the Run Immediately wasn't working and someone responded that there were issues. Was this resolved? I see the original question is from 2019 but when I tried using "Immediately" today it doesn't seem to run either. I was hoping to use "Immediately" as a run time since the person who owns…
-
Calendar View change dates with predecessors
Is there a way or work around to do the following. We really like the calendar view on smartsheet for our construction schedules. It is really easy for our project managers to look at tasks on the a certain job. (as well as what subcontractor is workig on it. Is there a way to change the start date on a task even though it…
-
Case sensitivity when using data mesh
I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…
