-
If And Formula not working
My formula is not working but I also don't know that I am using the correct formula. I am trying to pull a number from a different sheet (a number from the PAC Weekly freezer reading max temp column) and want to pull that number only if it also has a match of the date from Week 1 and the freezer number =IF(AND({PAC Weeklyโฆ
-
using a filter selection in dashboard to filter out account
Hi I have created a dashboard where i want the user to be able to filter out month and the account. I have created a sheet that is taking the data out of 14 sheets and populates the first row based on the selection made in the dashboard. i have done that using a form that has 2 fields (account and month). The data is thenโฆ
-
Hello all ,I have two columns to pull info from in my sheet
One column Is State and one column is KEO Estimation Range, one contains In Progress and the other initials of the estimator . My goal is to determine how many rows are in progress and how many belong to the estimator in question ? simply put if I have 20 projects in progress and 2 belong to the initials DR ,that is theโฆ
-
How to identify if Contact -OR- Text is in a Contact column?
Hi everyone - We have starter task templates that we use when we initiate certain types of work. The templates have a Contact List column that is initially populated with ROLES (e.g. project manager, designer, tester, etc). The ROLES are then populated by the project team with the actual CONTACT names, based on the teamโฆ
-
Enter invoice amount in appropriate column according to aging
Hello- I am trying to have the invoice amount appear in the appropriate column based on the date. So an invoice from Dec 1 would now appear in the OVER 30 day column and on Feb 1 would jump to display in the 60 day column. =IF(CHOOSE(MATCH(TODAY()-[Invoice Date]@row,{-99999,0,31,61,91,99999},1),"Future Date","0-30โฆ
-
Calculate Date Column dependent on number column
Hi Everyone, I am looking for assistance writing a formula for one of my sheets. I have the following columns: Visit Date Screening Score 6 Month F/u Date 12 Month F/u Date What I am looking to do is have the 6 follow up dates calculate from the visit date only if the screening score is above 9. If it is 9 or below, Iโฆ
-
Sum If Multi Drop Down Contains @Cell
I am struggling to get a formula to work correctly. I have a "Crew" Column which is a multi select contact column. I want the crew to be able to select multiple members and enter a single "Hours" for the day. For example Antonio and Tacho work the same job for 10 hours. Then to have each persons total hours for the projectโฆ
-
Vlookup, match, index
I have tried them all and cant always get what I want. I am working between two sheets. I want to search for a value in one of those sheets that could be anywhere in a range of about 40 different columns and many rows. Right now, I can only get it to work if the search value is in the far left column. help if you can
-
Help on an If Then Formula
I have columns with checkboxes showing whether or not a person completed a course. I would like to enter a formula that shows if all the columns checked, then Assured Instructor should show an "X".
-
Nested If & And error
Hello, I'm relatively new to Smartsheet and am having an issue building a nested if/and function for one of my grids. I have 2 columns ("Effort" & "Impact") and am trying to get 4 unique values based on the numbers - If Effort@row >12.5 and Impact@row<45 show "Kill" If Effort@row>12.5 and Impact@row>45 show "Challenge" Ifโฆ