-
Creating an approval form from a submitted user request form
Hi, I have successfully created a form that allows a new user to provide their information, their requested access level, and their supervisor's name. When the new user submits the form, I want another form to be triggered and sent to the supervisor for their approval for the new user. Thus, the form would include the new…
-
Automation not triggering
I have two automation's that don't seem to be triggering. The first is when a row is added to the sheet, but the Assigned To column is left blank, the Status column should change to not started. The other is when the Done box is checked, the Status box should change to completed. Any Ideas on what I;m doing wrong? There…
-
Saving default colours for dashboard widget graphs
I have a dashboard widget that displays a pie chart. The pie chart shows the number of high, medium and low priority "issues" recorded in a sheet. I have built this into a workspace which I copy to use on various projects - sort of a template set equivalent. Is it possible to "pre configure" the graph to use specific…
-
Drag-and-drop attached files
Hi there. The problem is that recently I can't drag-and-drop attached files from smartsheet to the desktop. Please, anyone, know how to solve such a problem? And the second problem of how to turn back the old interface. Because what I saw today upset me. Not a convenient innovation.
-
Automation Failing
I have a move rows automation that will not run, even if I push it at the single line level. I have a sort of multi level baby database I work with it's built of 5 total sheets with the fifth sheet being a rotating retirement sheet. sheet 1 is where new data is pasted in, once new data is added it's moved to sheet 2 sheet…
-
Importing sheets to Excel or PDF
HI I am new to smart sheet , I have 2 quick question 1: When importing sheets to excel pictures are not copied 2: When importing sheets to PDF there is a limitations of 100 pictures Is there a workaround this as I use large sheets with lots of pictures which needs transferring on regular basis Any help will be appreciated…
-
Need Help with Index Collect Formula
Hello, The formula i am trying to put together is below: =INDEX(COLLECT({HBC Master File Product}, {HBC Master File Formula}, HAS(@cell, [HBC #]@row), {HBC Master File Plant}, CONTAINS(@row, "CBG COLD SPRING - G")), 1) I want to search another sheet (HBC Master File Product) in the formula column to match the HBC#, the…
-
Smartsheet version
Which is the current (web) Smartsheet version? I cannot find it anywhere... Thanks!
-
Recurring Task Tracker
Good afternoon, I set up a recurring task tracker for use by different groups within my department but am having trouble setting up the recurrence for automation. I would like the automation to begin the 25th day of each month (irrelevant what day of week) and repeat for the next 21 calendar days. As I go through the…
-
Best way to adopt half day allowance
I have a Smartsheet program spanning over 1 year which and I only want to include half days for work on Saturday. What is the best way to do this?
