-
Check Another Sheet for Value across Multiple Columns
In Sheet 2, I am looking to search Sheet 1 for an instance of a value, that could be in one of four columns. Sheet 1 COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E | ABS 123 | March | 26444 | | 43454 | ABS 456 | June | 87834 | 45003 | | ABS 789 | August | | | | ABS 000 | October | | | 36543 | There are four order…
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
-
Selecting only one checkbox
Is there a way to make only allow the user to select one checkbox? If they choose one, the others are unchecked? I have a survey with 5 options (1 checkbox for each). If the user selects #1 but then selects #2, I need #1 to uncheck.
-
Help with formula with multiple criteria
Looking for some help writing a formula multiple criteria... I want the formula to read the column "openings" and determine cost based on how many openings in the job. 11-20 openings = $225 / 21-25 openings = $250, etc... I tried building the formula with mutlitple IF statements, but i keep getting an unparceable error.…
-
Tracking changes to a Column within last week
Hello, I'm trying to find a way to count the number of items which have been updated to a 'complete' status within the last week. I have 10 sheets and they all have a status column (not started, started, complete etc.). I've tried using the 'modified date' column to determine if the status was updated, although I'm aware…
-
Using IF formula to drive status
Mine is a little different than what I've found here. I have 4 columns: Closed Date and Completion Date, Status column that has 4 choices: open, closed, complete, overdue and a Due date column. If closed and completion are blank, the status should be open If Due date has passed, status should be overdue. If completion is…
-
Automate a rent increase on certain date
I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount. I can use the Index and Match to pull in the amount, just needing…
-
Totaling percentages linked from another sheet
I am simply trying to get an average percentage in a parent row from children rows that are linked in from another sheet. Is the fact they are linked what is causing my error? Currently I'm just using: =AVG(CHILDREN())
-
Easy way to count unchecked boxes in a column
Hi there, I'm trying to create a reference that counts the number of unchecked boxes in a column from one of my form-filled Smartsheets. I'm trying to use the formula "=COUNTIF([column2]:[column2],=false)", where "[column2]" is my checkbox column. The problem I'm having is that using this formula counts all pre-generated…
-
Pop up form requiring description
Hi Everyone, I am trying to create a checklist for my organization and have everyone check off on their task by inputting a "yes" or "no" using a drop down list indicating weather the task is completed or not respectively. What I want to happen is, if they answer "no" on the Smartsheet, that there will be a pop up of a…