-
Ending Digit Missing in Text/Number Column
Hello all, We are using a SmartSheet to track machine related problems. The column we are having issues with has text entered such as: 118.2103 (Model.Serial Number) I figured that if I used the Text/Number Column it would save whatever was entered. What I am experiencing is that the last digit is missing from each entered…
-
Alert someone in automation not working
Hi, In my automation flow the action "alert someone" does not work, no alert is sent. However, the actions requesting an approval are sent and work properly. Strangely enough, if I modify the action 'alert someone' to 'request an approval' that goes through and an email is sent (without changing the conditions or trigger)…
-
Cross-sheet Reference not using latest data from target sheet
I have a sheet (VSM Meeting Request may) with a date column (Created_) that does a date calculation (=IF(Created@row = "03/05/21 6:44 PM", CreatedCalc@row, Created@row). I then I have a reference to that column in another sheet to calculate some metrics. Everything was working fine up until this morning when all of a…
-
How do I move a sheet from folder "Sheets" to a subfolder ?
Hi, How so I move a sheet from folder "Sheets" to a subfolder also located in Sheets. I underline the fact that the Sheet that I want to move it has been shared with me and I'm not the owner of the sheet. When I will save it in the folder I created, I don't want to appear as a owner. I just simply want to save it as it is…
-
Automated Workflow: Move Rows & Parent/Child Structure?
Hi! I have a contract management sheet where I have individual years within a contract broken out as child rows underneath the parent contract. I would like to be able to automate a workflow to move the individual rows to an archive sheet when the year is over, but I'm not sure how to do that while keeping the parent-child…
-
My Form did not populate the Grid Sheet
Hello, I've had a form populate a grid for many months, but recently a new form submission came in. But the sheet did not populate the next row with the data on the form. Any suggestions on how to debug? I've never experienced this issue before... Thanks, AE
-
Automation - what happens when two people are asked to complete?
I have created an automation in place of a form. The emails/request for updates are sent to, in many cases, more than one person. In testing, it appears that the cells are overridden? How would I prevent that from happening? Many thanks
-
Show the children of a row in a report
Dear all, I have a sheet with a hierarchy of rows (parents / children / grand children), I have a report that selects parent rows, I would like to show the children / grand children of the selected parent rows in my report even though the children / grand children do not meet the selection criteria. Is this possible?…
-
Form Dropdown Select and Quantity
Hello, I am trying to create a form where users can select a product from a dropdown and enter a quantity. e.g. the category is blue t-shirts, the dropdown are sizes (S,M,L) and users can select S and enter in 5 for quantity. I would also like users to be able to make multiple selections each with quantities from the same…
-
Is there a way to dump the contents of a report to a sheet?
I generate a report from different Smartsheets using a condition (any Flagged rows) and then I want to be able to number the the resulting list. Is there a way to dump the contents of the consolidated report to a sheet so I can number the resulting list?
