-
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…
-
Need help with a formula to determine if all responses have been received for each group in the Smartsheet
Hi! Thanks in advance for taking a look! I have a Smartsheet that has a line for each person being reviewed as well as their "client number". I created a helper row to let me know when each person has completed their actions, but I'm having a hard time finding a way to indicate when everyone for that client number has…
-
Why the dropdown menu is not searching for the first characther anymore?
Since a few days ago, the smartsheet started working differently. I used to write in a cell with dropdown menu the number "5" for example, and would show me the option "5 - built" straight away as first option. Now if I do the same, the first option that appears is "0.5 - waiting", this is really annoying because after…
-
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…
-
COUNTIF Cells within a range are NOT BLANK
Hello, need help with a formula - I need to count within a cell range how many are NOT BLANK, this is the formula I currently have that is not working - what needs to be changed? /COUNTIF(Charter@row:[Retrospective/Lessons Learned]@row, <>"")
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
#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…