-
my collect function doesnt work
I have used a collect function workaround from one fo the community boards, and it works wonders. however it doesnt seem to work when this new data lookup range. note the data lookup range has been edit with the =left function. =JOIN(COLLECT({Open Order Inquiry2020-07-07 Range 3}, {Open Order Inquiry2020-07-07 Range 2},…
-
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…