-
Help with a dynamic status column
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 dynamically update based on the check boxes in the columns. If all the checkboxes@row = 0 then status would be "not started" but if…
-
How to set up multiple criteria on countifs
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 understand it. This is what I use in filter This is formula I use: =COUNTIFS({IDEA Request Sheet Range 1}, =0, {IDEA Request…
-
What is the Default data type for "auto-numbers"
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 "auto number". In our project portfolio sheets I am using a Index Match formula to pull client groups and client name instead of…
-
INDEX & Match
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) info and Contract info. Column 'PC #' is hidden and each of the columns to the right of 'PC #' contain Index & match functions.…
-
index and match formula that works in some places and not others
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 and Attendance row works as expected. The data for overall status, scope, timeline, resources and funding are matched and…
-
How do I update my function syntax to stop getting the #INVALID DATA TYPE error?
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]@row) I've tried to add IFERROR in a couple places and it didn't help with anything unfortunately. My Task Duration is set as…
-
Formula Help: Count number of time "Yes" occurs in a row?
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. Can someone provide some guidance?
-
Advanced Formula #No Match Error
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 options Yes: 3rd party, Yes: Security, or No. I want to create a formula that will reference the entire master sheet and…
-
Ignore blank cells in concatenation
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 symbol is keep adding without any data in between, =Product@row + " " + Variant@row + "|" + [Product 0]@row + " " + [Variant…
-
Nested If And Not Formula
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 Status@row = On Hold, then Blue Finish@row = Blank, then Blank Here is where it gets tricky... If Finish is less than today…
