-
Formula to automatically link Week to Date
Hello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attached). We have this working with a long formula: =IF([wk 23]@row <> "", "06/06/22",…
-
Including Half Day Holiday to Timeline Nonworking Day
Is there a way to add half days as a holiday in a timeline (nonworking days)? EX: We are having a half day on Friday and Monday off for Memorial Day. I was hoping to find a way to include in this in the timeline (nonworking days)?…
-
How to populate a column in a sheet based on a column from another?
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
Control Center optional template issue
Hi All, We are using Control Center for our projects, we use it with 4 different countries and every country has it own set of templates that they can select when creating a project. So in total we have 16 optional templates that are unrequired and unselected. The country then selects their own 4 templates. And creates the…
-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Is there a way to allow users to email comments without viewing the smartsheet?
Hi, Is there a way to allow users to email comments without viewing the smartsheet? Is it possible to modify the email that gets sent when you @someone@something.com from the automation@app.smartsheet.com, remove the reply in smartsheet box so they just reply to the email? When you add them as a commenter they can view the…
-
How do you move a row from one month group to another?
I am using a 12-month calendar template. I have content in one row for May, but need to move it to June. I know I can copy and past but this leaves behind the comments, files, and proofs. I have tried sorting in various ways and it does not seem to work. Do I have to change the formula? Or is there some kind of a way where…
