-
Why is the same exact function behaving differently for 20 rows?
I have the following function on over 140 rows in a project plan: =IF(TaskCheck@row = 1, "Task Done", IF(ISBLANK(Predecessors@row), "Ready to Begin", IF(INDEX(TaskCheck:TaskCheck, VALUE(LEFT((Predecessors@row), 2))) = 1, "Ready to Begin", "Don't Start (Predecessor Incomplete)"))) If the predecessor is not complete the task…
-
Formula to Trip a Flag
Hello, I currently have a formula in my sheet that trips the Flag function in my "At Risk" Column if the due date is less than today, and the status is NOT waived. The formula below works great. However, I would like to include "PFiled" and "Efiled" to the status already referenced, but I'm stuck. Can you please assist?…
-
SUMIFS with sheet references.
Hello, I've got this formula working like this. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation") However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL /…
-
Contact List appearing as email address and not by name
Hello, Has anyone encountered this issue? I have a contact list column and the values were entered with a name and an email, when pulling a value into a column sometimes it shows as a name (which is how we wanted to show) and other times as an email address, even for the same contact. This column's info is linked to a…
-
What is the syntax to reference another sheet when using formulas?
I want to use add up costs in an AMOUNT column when the value in the CATEGORY column is SHOES and this display this in a Summary Order sheet. Can someone tell me what is wrong with the syntax of this formula: =SUMIFS({REFERENCE SHEET}, AMOUNT:AMOUNT, CATEGORY:CATEGORY, "Shoes") I've already tried the Learning Center notes,…
-
How to count DISTINCT countries within a date range?
Quarterly, I am required to show how many DISTINCT countries were reached by our instructors. I need a formula that would count the DISTINCT countries reached between (for example) 1/1/2020 thru 3/31/2020 (for first Quarter reporting). I've attached a snippet from my Smartsheet to show the setup. I have the formula for…
-
Friendly Reminders
Hi there, I have two troubles with the tool, I hope you can help me and I'll grateful for that First: I'm automatizating my process with friendly reminders, but these one e-mails their looks like a spam e-mails, I mean, the vowels with tilde doesn't recognize it and show a question mark in that space, this action it's…
-
IF THEN using multiple sheets and multiple columns
I am looking for a formula that brings over data from a column only if there is a date in another column. =IFERROR({Dallas Tracker NEW Start Date} > 1, (IFERROR(INDEX({Dallas Tracker NEW Mileage}, MATCH([SEGMENT ID]525, {Dallas Tracker SEGMENT ID}, 0)), ""))) So basically if there is a start date in a specific column, I…
-
Use Conditional formatting to mark cells that contain formulas
Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advance for your help. Cheers, Bill
-
Combining cells from one sheet into a single cell on another sheet
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Column3]1). In sheet2 I only need the info from Column2 and Column3. Is there any way to do this from a…