Hi- I have a {{Status}} which is a drop down containing the follow options "Not Started", "In Process", and "Complete". I have 4 columns which are checkboxes. I would like the {{status}} to dynamicall…
hi, I want to set up formula to count ideas that are: 1) Not checked in SCC, 2) Approval Status is not "Cancel/Reject", Portfolio is "ADA/Commerical", but it always gives me count as 1 only. I don't u…
I've created a "Client Database" using a sheet. We had 400+ rows of details input via an upload during the setup. Subsequent clients are added via a Form and the new client number is assigned via "aut…
I have what I am calling a 'Lookup' Worksheet. I also have a Change Order Log, an Invoice Log and a Contract Log. I would like the 'Lookup' worksheet to return all Change Order(s) info, Invoice(s) inf…
Hi, I have an index and match formula that works in some places and not others. I tried to attach a screen show that shows what I am trying to do along with this description. My formula in the Time an…
I'm working within a sheet and trying to calculate the number of days between two dates. Above is a picture of what I'm seeing and my syntax is below. =NETWORKDAYS([Start Date]@row, [Date Completed]@r…
Hi there! I am trying to write a formula that will count the number of times "Yes" appears across multiple columns in a single row. I am new to SmartSheet and having a hard time writing the formula. C…
Hello, I have a master sheet that I am referencing which contains multiples rows that I need reflected on my teams sheet. There is a column named "Vuln Mgmt" (set as a dropdown/multi-select) that has …
I want to concatenate multiple columns data in a cell but would like to add a condition to ignore blank cells, I used a "|" to identify two different data's but if there is any blank cells "|" this sy…
Hi all, I'm working to write a formula that displays a health ball (R,Y,G,B) that's based on a variety of logical expressions. Below is what I am aiming to achieve. Status@row = Complete, then Green S…