-
Index Collect partially working
I am trying to validate information using Index Collect function. It works when I look at the school's name, but when I add the 2nd criteria for the school district, I get the #Incorrect Argument Set error. SCID=the ID number SN is school Name in the criterion range DN is the district name in the criterion range…
-
Automation Not Working
Hi I am trying to set up a spreadsheet to trigger the Lead Installer to fill out the following columns when the date is reached. Every time I run a test it doesn't work either. Can someone assist?
-
Sharing reports with data without even view access to the source sheet
Today in order to share data in Reports we would need to provide view/edit access to the underneath sheet / source sheet. That's not exactly what many of users expect from Reports. This is a pretty typical task to have a data frame (source sheet) and using Reports provide access to certain portions of data to different…
-
I want to count number of days in a separate column,,,
I want to count the number of days in a separate column. I have a "Primary Column" with a parent row that counts the number of Weeks. The 'CHILDREN' rows are for each Week Ending with working days as 'GRANDCHILD' rows. I have a separate column named 'Days Count' where I want to count the total 'GRANDCHILD' rows in the…
-
Any Issues with Automations Being Slow or Not Being Triggered?
For the past three years, we've been using Smartsheet boards, with one board dedicated to managing our production workflow. Once a job is completed, we remove it from the board to make space for other active tasks. This main board also triggers an automation that copies metrics from the primary sheet to a tracking sheet.…
-
Looking for More Efficient Formula for Calculating Weeks
Is there a more streamlined method to calculate the number of weeks between a specified start date and a set date without resorting to intermediary calculations or a helper column? I currently employ formulas to determine the day difference between the start date and the set date, and then divide this figure by 7 to derive…
-
Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…
-
Creating an Automatic Step Numbering System for Tasks with Indentation
This discussion was created from comments split from: Looking to create a formula to count number of tasks.
-
Why did the format change on automated alert notifications?
Wondering if you could help me regarding the automation alerts based on changes to a sheet. They changed. The format was “normal” and worked yesterday. Today the alert is asking recipients to “Open in Smartsheet”. Can we change this back? My inbox is filling up with people clicking it and requesting access they shouldn't…
-
Customize Account Invitation Email
Currently, when users are invited to join a Smartsheet account they receive a standard, system-generated email with no custom message. This has resulted in some users contacting the sender or a Smartsheet administrator, if they know one, to ask whether the email is legitimate or a form of phishing malware. The system…
