-
Iferror(vlookup) not pulling all data from a cell.
I am using the Iferror(vlookup) function to track my teams inspections. Recently, I changed the form to have multiple locations, and since then the iferror(vlookup) is not pulling every locations date from the data set. Picture 1 is an example that pulls the data properly, picture 2 does not pull the data, and picture 3…
-
Count distinct values within cell
a
-
Column IF AND Function Help
Hi all! I cannot seem to get my IF AND statement to work and would sincerely appreciate some guidance! I am attempting to alter/update a cell on one sheet that acts as a matrix for employee training which is based upon information from a reference sheet. Essentially, a row in the reference sheet is populated every time a…
-
Notification When a Date Changes
I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder. In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard…
-
=SUMIF for calculating budget on multiple rows.
Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc. I tried to write a =SUMIF and it…
-
Combining IF functions to read multiple columns and create a flag
Hi all, I am working with the attached sheet trying to create a few flags to appear when certain information is present. The 3 flag columns are '2 Weeks - No Data', '2 Weeks - No Check Ins', '2 Weeks - No Paired Check Ins' and I have formulas within each reading the 'Check In Type' and 'Last Wk Check In' columns. Below are…
-
Question/Help with IF Statements
Hello, I'm working on a sheet for new employees and I'm trying to build a simple IF statement that will display whether or not the employee started, based on today's date. =IF([Start Date]@row = TODAY, "Yes"), IF([Start Date]@row = >TODAY, "No"))) I must be doing something wrong. Do I need rearrange the formula? I'm trying…
-
Update Formula to Include When New Columns Are Added
I have a sheet that tracks the number of hours by the team on each project. When a new project is created an additional column needs to be created (if anyone knows of a way to have it automatically added when a new project is created from a template that would be amazing) and named with the new project name. Then the Team…
-
Use Conditional formatting to mark cells that contain formulas
Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advance for your help. Cheers, Bill
-
Using INDEX/DISTINCT with OR function spread across multiple ranges
I use the following formula to condense data from source sheet to destination sheet with the "distinct" feature possibly combined with an OR function. Something like =Index(Distinct(OR({FLOWER UID}), Number@row, ({SHAKE UID}), Number@row)) or =Index(Distinct(OR({FLOWER UID}, {SHAKE UID}), Number@row)) Source sheet with two…
