-
Formula help with Sum ifs
Hi, I have done a formula for Countifs =COUNTIFS({July Range unders}, <0, {July Range Manager}, [A/M]1) This works well and returns the correct data, however i now want the total sum of these entries so tried the following: =SUMIFS({July Range unders}, <0, {July Range Manager}, [A/M]1) But this is pulling back an Incorrect…
-
countifs formula stopped working
Hello All, Did something recently change? I have a dashboard that leverages a sheet for various counts. It has been working. I was away on vacation and they are no longer working thowing and invalid error. =COUNTIFS({Aimbridge Report Issues (Resolved)}, 0) – 10 =COUNTIFS({Aimbridge Report Issues (Resolved)}, 0, {Aimbridge…
-
Heirachy formula
I have a parent line with children underneath. I have a status column with red,yellow and green. Say I have 6 children lines under the parent line . I need for the status on the last entered children line to reflect on the parent line. If you close the Heirachy I will know what the last status was that was entered. Is…
-
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.…
-
Formula Within Next 30, 60, 90 days
Hello - Looking for help with a basic formula that will calculate how many projects end within a certain number of days. I have used: =COUNTIF({End Date}, <=TODAY(30)) I am not receiving an error message, but the result is much higher than the number is should be. Any help you can provide is appreciated! -Andrea
-
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…
-
Data Uploader - Expressions & Repeated Updates
Hello, I have three questions regarding Data Uploader. 1) In my source excel file I have First Name and Last name. I tried to build an expression to concatenate the fields (used =[First Name]+" "+[Last Name] but returned UNPARSEABLE which I would assume is because I am not referencing the line number. Is there a way to put…
-
Return "Late" if date is passed and box is unchecked
I have 3 columns: Planned Date, Completed Checkbox, Late I want a formula to put "Late" in the (Late Column) IF the (Planned Date) is passed and (Completed) is unchecked. If it is not late, I want to leave the Late cell blank. I want this to show on every row. Here is my formula for row 2. I'm getting #INCORRECT ARGUMENT…
-
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…