-
Countifs with Check mark
Hello, I am trying to use the countifs formula to return calculated value based on status of progress and if client field is checked. Below is the formula I am using, however receiving the #unparseable error. Any idea? The formula works when i have only one condition, however its returning the error when I add the client…
-
I have a formula to return the quarter based on a date. I would like to add the year also.
Here is the formula, right out of this community (THANK YOU!!): =IF(MONTH([Start Date]@row) < 4, "Q1", IF(MONTH([Start Date]@row) < 7, "Q2", IF(MONTH([Start Date]@row) < 10, "Q3", "Q4"))) Here is my awkward work around -Start Date | Start Quarter from formula above | Start Year from YEAR formula | JOIN Quarter and Year. Is…
-
Recurring Calendar events
I have a task sheet that shows our team's travel plans. In the rotation each team member will travel every six weeks which will be viewable in the calendar view. What is the best way to set these trips as recurring tasks/events? Will that be a formula or does Smartsheet have a recurring feature?
-
How to change cell value from another sheet
Hello! Basically, I have an automation set up to send anything that is on Backorder (when B/O is checked) copy it from my "Open Orders" sheet to my "Backorder Clip" sheet. I have two questions regarding this. How do I set a formula that will apply any changes made to my "Backorder Clip" sheet rows will automatically update…
-
My automations are not working?
Hello, I am having a problem where my automation isn't working. What I am trying to accomplish: when I import rows the status column will be blank. I want it to automatically set all new rows to "Not Started". IDK if I have this set up incorrectly, but I have no idea why it isn't working. Thanks for the help!
-
Check Box if B/O Qty is > 0 OR Status column says "Backorder"
Hello, I have been messing with this formula forever and I feel like I am just barely missing the mark, but cannot seem to figure it out nonetheless. GOAL: If column: "B/O Quantity" = 0 check the box, OR IF column: "Status" says "Backorder" check the box. If both instances occur still check the box. Okay, the formula I…
-
How to assign static Due Date based on IF function
From the table example below. When a specific value is chosen from the "Progress" dropdown column I want Due Date to have a static date assigned. Currently I have the following but every day the Due Date is updated due to TODAY function I used. Any recommendations? IF(Progress@row = "Waiting on Sales", TODAY(5),…
-
Counting cells with previous year
I have a range of cells in a different sheet, and I am trying to create a cross-reference formula to count the cells that are in a past year. In the referenced sheet, I have years 2011-2023 listed, and I want to count the cells that are not marked as 2023 that fall under a certain criteria.
-
Invalid Reference issue
I have a sheet where I am pulling data from 3 different sheets into. After a while (eg. if im coming back on to smartsheet) #Invalid ref error appears in all my cells. How do i resolve this without having to edit the formula and relinking the sheets?
-
IF statement only half works
Can someone take a look at this statement and tell me where I went wrong? The Blue works (both), the Green works and the Yellow works. The Red, not so much. The things that should be Red stay Yellow. Any help would be appreciated! / Days Left till Due is a formula of =[Anticipated Completion Date]@row - TODAY()…
