-
Help with IF Statement with multiple SUMIFS
Hello, I am trying to sum up a range of data from two spreadsheets based on the same criteria. Here is my formula which is throwing an #UNPARSABLE error and I cannot understand why =IF(SUMIFS({Advertising Total Cost}, {Hardi}, =$Region$1, {Year}, =2021, {Month}, =[OCT-21]$1, {contract}, =CATEGORY@row) AND(SUMIFS({misc…
-
Decrement a funding total
Hello all you formula wizards ~ I'm down to the last test of a travel request module and I realize my formula is not working correctly so I'm looking for some guidance. I have an intake sheet where requests are submitted, then reviewed and approved, which moves the data to another sheet for further approvals. I need to be…
-
Flag task as late where task incomplete and past due date
Please help, I am trying to flag late tasks in a column using the following formula... I am getting a #INCORRECT ARGUMENT SET error...Please help =IF(AND(Status27 <> "Complete", (Finish27 < =TODAY()), "red")) thanks
-
Help with (date) helper column anomaly
I am using a helper column to provide a date from 'Date created' column that auto adds date and time. The helper column date can then be used to calculate days btw it and today. I am using the formula =DATEONLY([Date created]@row) but the helper column shows the day before as in the screenshot below. I have experienced the…
-
Hi All, I have a question about COUNTIFS()
The scenario: I am trying to count only the rows that meet two criteria. This sheet tracks requests for headcount by type and by year. So there are two columns among the data, one that states the year requested, and one that states the type requested. I have two ranges, one for each column in the formula. Each range only…
-
Archiving rows with formulas that reference other sheets
I've build a pretty large Smartsheet for tracking data yearly contracts for each of my 60-70 clients on therapy caseload with formulas in each row that reference other sheets and pull numbers from daily log forms. I need a simple process for archiving a row when the year contract is complete. I want to save a snapshot of…
-
Using "IF" with "And" for multiple criteria
Hello, I'm struggling with the syntax for a formula-I've seen examples within the community and can't quite get them to work properly for me. I would like to count the following: Count values where the following statement is true: column 1 =ABC, or, DEF, or, GHI AND where column 2 =123, or, 456 I've tried =COUNTIF([Column…
-
Relational Database?
Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with each other? Some language in the site alludes to needing to integrate Smartsheet with an…
-
Sum of multiplication of two columns
Hello! I would like to get the year spend for new hires in a company based on their expected start date and percent time allocation. I have a sheet with multiple departments, salary budget, percent allocation for hires (i.e., 100%, 50%, etc), and expected start date. So what I would like to do is: For Department "X" and…
-
Converting text to Date to populate Gant & Calendar App.
I have an Allocation sheet where I need the user to choose the month in the "Month" column and the 'Start' populates with the first date of the month and the "End" populates with the last date of the month so I can have a start and finish date to show the resource and Allocation on a Gant and Calendar app. I have tried to…