-
Sum If
Hi All, I need help with a formula. I think it should be sum if. I want estimated hours 28 to show the sum of cells 29:34 but only if %complete is less then full. Thanks.
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
Formulas and attachments
We utilize SmartSheet to collect information for complex implementation projects. We have applications where our users will be attaching documents to specific items/rows in a sheet. It would be awesome to be able to write various formulas to interact with the attachments. For example: Detect if there are any attachments…
-
RYG formula based on completion time and status
Hi, I would like to have a formula that shows me RYG status based on below criteria: -if status = completed and [Actual Finish] = [Baseline Finish Date] then green -if status work in progress (wip) or not started and [Actual Finish] is less than 14 past today then also green -if status wip or not started and [Actual…
-
How can generate a weekly report using formula and without using a Column Helper?
Hi, Please help me on writing a formula to calculate the weekly sales data. Please see the attached screenshot of my example data.
-
I can't figure out what's wrong with my formula. I keep getting an "#Unparseable" Error. Help?
Can someone help me figure out why my formula keeps giving me an error? I can't for the life of me figure it out: =IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + Green#, [8p LTC Peak]2 > 0), "Green", IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + [Blue]#, [8p LTC Peak]2 > $[8p LTC Peak]$1), "Blue”))
-
COUNTIFS within a Date Range
Hello, I have a column of dates that are formatted as dates. I am trying to use COUNTIFS to tally the number of instances in which a date from the column is less than 1 month from today, between 1 and 3 months from today, between 3 and 6 months away, and between 6 and 12 or more months away. For less than one month away, I…
-
Formulas Not Pulling
We currently utilize a very large global onboarding smartsheet. When a new hire accepts a position, the onboarding team uses a form to manually add them to the tracker so we can assign out the onboarding tasks and track progress. As part of a business initiative, we also have hidden column to track the amount of time spent…
-
SUMIFS and Contains conditions
Hi all- I have a formula that refers to another sheet to sum costs based on some criteria: =SUMIFS({Professional Services Project Costs Amount}, {Professional Services Project Costs Grant Code}, $[Budget Allocated]$8, {Professional Services Project Costs Category}, CONTAINS([Budget Category]28, @cell)) I'd like to add…
-
IF cell matches criteria in one column, THEN return other columns from matching row
Help, please! I am trying to search a MASTER sheet for ALL ROWS that match two criteria (MASTER Author-Partner matches the value in [Project1], and MASTER Project category matches Project@row), and then return the contents of certain cells within each matching row (Title/Topic, Product type, Status, Due Date). I have had…