-
IF Function
I just want to return the values of Completed or Not completed. If the column "Daily" = "#NO MATCH" return not completed otherwise return Completed Im using however Im not gettting "Not completed" when the Daily column is "#NO MATCH" Thank you very much
-
Please help! Need COUNTIFS with DISTINCT
Hello Community! I could really use some help. I've reviewed prior posts but am still not nailing it. I need to count the total number of "to be hired" positions based on unique/distinct ID and team. I've tried so many variations but cannot get it. Any help would be tremendously appreciated. Thank you!
-
Summary Sheet History
I have a summary sheet for my smartsheets. It contains several fields, including 3 fields that are updated weekly manually. I'd like to create an automated way to save the values of these manual fields ( Date, text, text ) so I can refer to them for historical purposes and evaluations. I can't find any way to do this. Anyโฆ
-
Change Status and Health when % Complete is updated
Hi- I'm struggling with trying to automatically change my status and health columns depending on date changes. Is the following do-able? If % complete is = to 100% then status turns to "Complete" and my health symbol turns blue If % complete is < 100% and my Finish date is greater than 7 days then status turns to "Inโฆ
-
How can I compare two lists for overlap?
Hello, I'm trying to compare the values in two multi-selection dropdown lists to see if there's any overlap. Say both of them have options (a, b, c, d, e), and List 1 contains (b, c) and List 2 contains (c, d). Is there a way to return True because they both contain (c)? The larger goal is using this to add a contact toโฆ
-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my currentโฆ
-
IF(AND(NOT(ISBLANK Formula Trouble...
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula. If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have. =IF(AND(NOT(ISBLANK([Provisional Requestedโฆ
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheetโฆ
-
IF(AND
I am building out a risk register and I'd like to use a formula to calculate the Risk Level, it will have to pull multiple combinations to get the formula though and I'm hitting a snag in my IF(AND formula. Essentially it needs to breakdown info input in my Risk Probability + Risk Impact columns to calculate the Risk Levelโฆ
-
Convert count of days to months
Hi, I have a "Contract end date" field. I used the formuale to calculate the "remaining days" by using Today - Contract Date that gives a days value . Eg. 100 Questions - Need to convert this value of 100 to Months and days format eg. 3 months and 10 days Can you please confirm Thanks!