-
Setting a default value in a sheet
Hi Everyone , Is there a tip to set a default value in a sheet column ? I know it is possible to do it by a webform , but it is not my concern . I have a drop-down list column , with 2 items : "Oui " et " Non " . How can I manage so that " Non " value is displayed in the column by default every time a new row is added .…
-
Automations Using Distribution Lists
Is there any way people have found to use a company created distribution list and have Smartsheet send the automation using that DL? Example: DL_All IT (goes to all IT in the company). Pretty sure that Smartsheet only sees the words "DL_All IT" and not the underlying emails that go with that DL. Wondered if people have…
-
How to get dashboard to pull from cells in input sheet once a new date is entered?
New to SmartSheets - Created a simple dashboard as you can see below It is pulling from the input sheet below My issue - The dashboard displays what I select on the input sheet. How do I get it to stop displaying 1/31, and immediately only show 2/1 once a new date is entered? Essentially, I want to display productivity on…
-
I cannot convert my if statement to a column formula
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement. =IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico",…
-
Activity Log not working
Has anyone noticed that that Activity Log has stopped logging row and cell changes? It appears to have happened on 2/2/2023 around 11:00 AM EDT. This affects ALL sheets, old and new regardless of workspace or licensee. Logged a case with support. Check your sheets!
-
Automation Notification without link to the sheet.
Is it possible to nofify/alert someone using an automation with these characteristics: Send an attachment in the notification Not sending the link to the sheet Thanks for your responses!!
-
How I can manage the Resource view
Hello Everyone, I am managing resources for my team, In some sheets, I am using Planned start and Planned finish dates and I have enabled the project settings with planned dates. so now what is happening if they are planning for tasks in the future and mention 2d in durations and so, it is calculating 200% in resource view…
-
Project ID Sequence Issue
Hello, I was setting up my Project Intake sheet and form with my scoring calculations and testing these. I tried to paste the formula into multiple rows so the calculation would execute once the form was submitted. In doing so the intake sheet recognized these as new projects and filled in some of the metadata in all those…
-
Displaying actual/planned progress in dashboard
Hi, I have a construction gantt programme in Smartsheet with start & end dates and % complete columns for each task plus a 'parent' row for overall progress. Is it possible for me to take data from this programme to display with a simple bar chart or line graph our actual progress against planned progress ? Not sure how I…
-
Cross sheet formulas referencing different columns
Hello, When creating a formula with cross-reference sheets, do all of the columns need to use the same source? For example, I would like the second part of the formula pull from 2 different columns, but when it's pulling from the same source. When I change the formula, it affects the others too; I get this notice.