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…
Hi I am using the Summary area and trying to create a formula that will show me when my Finish date is greater than today's date AND the status is not "complete" then say Overdue and if false say None…
Hello! I am trying to write a formula that pulls information from one sheet into another based on a criteria. I have successfully written the formula to work for a single row, but can not get it to re…