-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
Using forms in mobile/app
Hi Everyone, We have a form which is filled by the site team. In one field, they have to update the remarks. It is a multiline textbox. But while updating it via mobile/app, there is no option of using 'enter' key to change the paragraph. Are we missing something or is it designed that way. Thank You!
-
Automatically adding rows to sheet and automatically nesting them under parent row?
Is it possible to have a rows automatically added to a sheet (for instance from a form on another sheet), and have the rows automatically be nested under the correct parent row on the target sheet? For example, if the Primary column is "project name", and "parent project name" is a field on the form, is there any way for…
-
Multiple Approvals Per Row
Hello, I am looking for a workflow solution to our document approval process. Currently we have a Confluence page where five individuals attach a picture of their signature. I would like to set up a sheet to manage approvals of several project documents. The approvals function can currently do this, however, when I send…
-
Creating multiple ranges without formula
I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-programs and then up to the overall program. Is there any way that I can go into an…
-
Max Cost per Year
I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([Date of Incident]:[Date of Incident], <=DATE(2020, 12, 31), [Date of Incident]:[Date…
-
Error when 2 people enter rows on a sheet at the same time
We have encountered a problem in our Sheet where if 2 people work on it and insert new rows at the same time they merged into 1 row. This is quite a big issue with our work as each row is a piece of practical work that needs undertaking, therefore 1 row missed is 1 piece of work missed. Is there a way to prevent this…
-
Is there a limit to how many unique forms I can create for a single sheet?
I am working on a solution that requires a unique url form for each client - I'm passing hidden fields in each form to indicate which client submitted the request - is there a limit to how many forms I can add on a single smartsheet?
-
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
-
Creating a Formula for Dates and Traffic Lights
Hi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - formatted as a green traffic light * "60 Days Since Contact" - formatted as a yellow traffic light * "90 Days…
