-
Search a specific value within a range
Hi, in this example, I would like to search a value (each cell in Column 5), within a range in Column4. I tried using formula HAS and CONTAINS, but it seems the criteria or search value is not recognized when I click on a cell in Column 5. Appreciate if you can help me to find a way to pull this off. Best regards,
-
If with And Formula help
Hello, I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days. Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micro/QC?]@row = "QC", 1, 0)) I'm getting incorrect argument set error and can't figure out…
-
Countifs with reference to another sheet
Hello, I am trying to use the following formula: =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,"]) and =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,") but it keeps coming up as "UNPARESEABLE."…
-
Date 6 months out (to the day)
Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also new at SS, so I am just now learning syntex, etc., regarding functions and formulas.…
-
Programming with Smartsheets
Is there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?
-
need help with an IF function
Hello community, I am trying to come up with a cell formula that is a simple difference function, but I need it to be triggered by the number in another cell. It is for an inventory/ordering sheet. Someone will count the inventory and type in the "QTY ON HAND". there is also a column for "MINIMUM QTY NEEDED" which is…
-
Date Formula Automation
I am trying to auto generate a start and end date for each task in a project tracker. I want the start date of the new task to look at the prior task, add the number of days to complete and then calculate the nest start date (and end date) of the task after it. For example, Review Start 1/14/2022 End 1/15/2022 Duration 1d…
-
SUM a value found in a string within each cell across a range?
Due to memory limitations i have all projects rolling up some user metrics data into a single cell per project. This cell has a text string with a value, followed by another text string and value, over and over for all my variables, for example, each project will have this: Person A status /0 Person A task risk /5 Person A…
-
Indirect style look up from another sheet
Hello, I am trying to access data from another sheet using a reference to another column within the row using a sum formula usually in excel I would create a =indirect() reference, how could I replicate something like that within smartsheet.
-
How do I use the INDEX & MATCH function when trying to pull information from one sheet into another?
Hey All, Reaching out to the masses to hopefully get some help. I need to pull information from sheet 1 into sheet 2 using the INDEX and MATCH functions. Sheet 1 that I want to pull information from has: Child rows Task Name column (The list of tasks have the same name in both sheet 1 and sheet 2) Actual Date column What I…