-
Convert SOME of the blanks to zeros
I am creating a new sheet, and so far, about 30 columns. Of these columns, 12 are metrics which require a numeric value. I would like to create a Workflow to convert the blanks in ONLY these 12 columns to 0. It is likely that some of my other columns will be blanks, but I do not want them to be converted to zeros. If…
-
How to flag the second largest date in a sheet
I have a sheet that collects responses from a form, specifically collecting status. I pull this data in to a second sheet to be able to show current and previous status on the same line. To do this, I am creating a helper column to flag the second largest date. I know how to find the most recent entry (largest date) using…
-
smartsheet forms
Hi all, is there a way to view who can access the smartsheet forms either through API or the website? We add people to our contact list and they can see the form at first and the second day they can't see the form anymore.
-
Automatically update a form name when the Sheet name is updated
There currently isn't a way for a form on a sheet that comes on a template to automatically update once their Sheet name is updated, in Smartsheet. Could you make it such? An alternative would be to link a cell to a field in the form that would be pre-populated when a user goes to fill it out.
-
Autofill Form
So if I have a purchase request form I want to select Item A, for example Once I select that, I want it to give me than a list of budget numbers to pull it out of (Item A for engineering, Item A for software, etc.) Then autofill with a set price, and I put how many I need and/or show me how many are currently budgeted for…
-
Adding parent rows and subtasks with a form submission.
I would like to add subtasks automatically from a form submission. The scenario is, we have requests coming in with a number of details for the overall request (due date, project title, etc) but each request has up to 10 tasks associated with it (but they are always different) - is it possible to have a form automatically…
-
Add Comment Section to a form
Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.
-
Comments section - ability to add in forms
Hi all, I saw this had been asked a year ago and it was suggested to use Zapier, but that's not a solution I can use. Are there any plans to enable the comments so it can be added as a field in a form. We use forms for initial intake, and have to create a column called "Notes" so comments can be added. It redundant and…
-
Adding attachments to a row with 2 forms
Is there any way a row with files in the attachments can be merged with a new form entry that also has an attachment. Currently I am using formulas to join the original row with the new form data but since forms cant add to existing row I cant figure out how to have both attachments on the single row. Is there any way to…
-
Why isn't the background color of my forms carrying over to new projects?
In the project blueprint, we have forms set up & the background color is set to blue for all forms. However, when we create new projects, the background color of the forms is showing up white (making our white logo invisible). Is there a way to fix this? Has anyone else had this problem of the background color reverting to…