-
IF, THAN, ELSE statement
I am needing to create a formula and I am stuck. I have 3 columns, "PO Cut", "Completion Date" and "Number of days" What I am tying to do is have the "Number of days" column show how many days have passed since the "PO Cut Date", unless there is a date value in the "Completion Date" column, then just calculate number of…
-
Automated Workflow to send Managers a Report Link
Hello Smartsheet Community, PROBLEM: I have created an automated workflow to send out a link to a report I created for the teams upcoming tasks over the next 2 weeks. However, I've begun the practice of sending the reports to myself first as a test, so that I'm not spamming Managers with erroneous reports. Good thing,…
-
Is it possible to share a sheet with only certain people in the workspace?
I would like to share a sheet but not with all the users that are in the workspace. Is it possible? Also, I would like to give access to that sheet to other people not in the workspace. Is it possible? Thank you
-
Is it possible to have text hyperlinked in an alert message?
Hi there, I want to make sure my alert emails look as neat as possible, but so far I have only been able to drop links in the alert message with the full URL text hyperlinked. It would be great if I could do something like this within an alert message: Is this possible? I tried hyperlinking a cell with display text in the…
-
Mary Corvalan
How do I remove myself from workflow alerts when I am the editor? Similarly, how do I remove alerts for others who are editing. for example, my manager gets an alert when they make changes, they only want an alert when someone else changes the sheet.
-
Notification when web form is submitted
I have a contracts workspace set up with a form attached to the main contracts sheet. Employees can submit a request for a new contract using the form, and this will auto-populate several columns with the data we need to create the contract. I'm trying to figure out how to add an alert/notification so that our contracts…
-
Taskbar delete
Hello Do you know if it is possible to remove the taskbar in sheet Thank you in advance
-
How to Auto-populate form with Request Number
Hello, I am creating a form for customer's to input data into our sheet. This form currently asks for "FER Number" which the customer is currently requested to input. However, I'd like to make this "FER Number" auto-generated/auto-populated. I'd like the form to reference the last input "FER Number" on Smartsheet (bottom…
-
Space to view Product Enhancement Requests
Hello, I'm new to Smartsheet and surprised to not find (at least not easily) a space to view Product Enhancement Requests submitted by other users (and soon to be myself). I've found several folks asking for certain features in community posts and they are directed to submit a form. I don't want to duplicate a request that…
-
Highlighting Duplicates
Hi Guys, I read some previous articles in community to highlight duplicates but it did not work for me. I am trying to highlight duplicated submitted in the building number column. can some one pl help me.