-
Display Attachment Names in a Column
Hi everyone, Is there a way to display the attachment name(s) in a column?
-
Checkbox if a multi selection drop down is used
I am currently trying to check a box if there are multiple options selected from a drop-down menu. The goal is to check the box if it has more than one workstream selected from the drop-down menu. There are multiple options that can be selected which are listed below. Servicing Transformation Production Transformation…
-
Count days from Start Date enetered and stop count when Finish Date is entered
Good day, If someone could please assist. I'm looking for a formula that counts my "wayleave" days starting from since the "wayleaves have been submitted, and stops the count as soon as the Actual Finish date is entered for the "Wayleave". Ps. Should also be "NETWORKDAYS". Example Columns: Column "ROW 1 Actual Start": Date…
-
#DATE EXPECTED
I have a column that displays the date from a reference in another sheet. However there is a different column on that the source sheet where a date can be entered and it should display that date if entered. I tried to error trap for blanks but I am still getting #DATE EXPECTED. Here is the formula for context.…
-
Referencing another Smartsheet when #NO MATCH is found
Hello, I've been struggling to find the appropriate formula and AI hasn't helped either. Here is some context as to what I'm trying to accomplish. In my "calculation worksheet" I have a table with Data Links setup. These all work as intended with no issues. The problem occurs because after an items has been marked…
-
Trying to build a helper column to identify duplicate values but the cell value returns "NO MATCH"
I am trying build a helper column which will be ticked if the value under the column PROP_CD has a duplicate. I am currently using this formula =IF(COUNTIFS([PROP_CD]:[PROP_CD], [PROP_CD]@row) > 1, 1, 0), but all the cells return error "NO MATCH" Would appreciate any help or insight…
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Does the cell history come over when a row is moved from one sheet to another
I have written an automation that moves content from one sheet to another when certain criteria are met. I thought the cell history came across with the row but when I click on "View Cell History" after it is moved, I only get the history for the move and nothing prior. Is this working as designed?
-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…