-
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…
-
Need help with using a COUNTIFS with OR
Hi, I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location. Ticket Active Status for Location = Location <and> Status [Open <or> In Progress] My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress. I keep getting…
-
Ref SUMIF example in Help
Hi, Referring the SUMIF example in the Help article https://help.smartsheet.com/function/sumif, it is not clear to me why =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3) has the result 3,115.00, and not 2,303.00, that is 1,491.00 + 812.00 Thank you, Elena