-
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…
-
Conditional Logic Forms
We have a form that will have yes/no logic. If Yes(problem is resolved with the previous information provided in logic) is selected we want them to back out of the form or display a "thank you, please submit if you have any additional questions" It doesn't appear the functionality is there, but does anyone have work around?
-
Is it possible to combine vlookup, join and collect AND reference an external sheet?
I'm trying to group information together from a second smartsheet, but the information requires a vlookup so a typical join/collect won't work. In the first smartsheet I have a company ID in each row that I want to look up, and in the second smartsheet there are hundreds of rows that contain company IDs in the first column…