-
Moving a row from one sheet to another sheet using an automation
I am just starting to use Smartsheet, particularly in the creation process, and I'm navigating my way through it slowly. In previous instances, Smartsheets were already created for me and my team's use. Currently, I am attempting to set up tracking for open quote requests to manage our workload effectively and communicate…
-
viewing capabillities
I have a summary sheet, someone has viewing capabilities. But they are seeing it blank..... It tells them that " I need to purchase a license, otherwise I will have limited access. " How can I fix this? They need to just view the sheet
-
Sharing worksheets for View-Only
I have a single Pro licence and need to send URL's to various colleagues so they can view current status of project. No editing permissions are needed for these users. Am I right in thinking I should be able to do this? Everybody I have sent the link to says they are being asked to register to a free trial (not what they…
-
help working with my team
I joined with a Pro account today. my work partner and I both have Pro accounts, but I can't access or edit a sheet that he created. What does he need to do to give me edit/revise access?
-
Multi-lingual functionality
Is there a way to have system messages appear in English on one form and French on another form-driven from the same sheet. The only way to change the prompts so far is to change my personal settings which impacts all sheets.
-
Automation workflow not triggered when changing columns in sheet
Dear smart Smartsheet users, I have a question regarding an automation flow that does not work. I have a sheet called “submit timesheets” containing the following 4 columns. ID, Employee email, Calendar Year, Month. I created a form where users could indicate which timesheet they would like to submit. I also have a sheet…
-
How to send alerts with link to the sheet WITHOUT sharing changes?
I have a smartsheet that includes automation to alert users when the sheet is updated. We want for emails this triggers to include a link to the sheet, as most users won't work primarily from smartsheet, but we cannot allow users to see the email address of the user who made the change for security reasons, and therefor…
-
How to add a formula to a whole column
Hi everyone, I only know how to add formulas individually, but I don't know how to add formulas to a whole column, can you please tell me how to do it? I can copy formulas together when I copy rows to another table.Thanks! Like this picture with fx
-
Duplicate numbers
Hi, I am trying the identify duplicated numbers using the =IF(COUNTIF([CAM Number]:[CAM Number], [CAM Number]@row) > 1, 1, 0) however, it does not seem to work with zeros in the front 00215.0009888 (The zeros are generated from a a system and can't be modified). However, if I remove the zeros from the beginning the formula…
-
Move Row Automation with Child Tasks
Hello, I'm using a sheet to track all projects for this year (Parent), their major tasks (child), and then the subtasks (child of task). Each row has a checkbox to click when completed. I want to set up a Move Rows automation for when the project is checked complete, that parent row & all its child rows get moved to a…