-
Week Number stopped working
Hi All, I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated. The formula is a helper column that is meant to count the…
-
[help] multiple IF formula; ancestor function?
Hi everybody! I've been testing smartsheet for a month and I was just setting up a document by myself when I found a mistake in my own logic. This is the formula I'm using: =IF(AND(ISBLANK([delivered by]@row); [start date]@row > TODAY()); "to do"; IF(AND(ISBLANK([delivered by]@row); [start date]@row <= TODAY(); [end…
-
Nested IF function
Hi I am currently trying to create an IF function that will mark a row as overdue if in the 'status' cell is "Paid" or "paid through urgent payment". At the moment i have it working for just one criteria, =IF(AND([Days Until Delivery]@row < 0, NOT(Status@row = "PAID")), "OVERDUE", "") where do i add the second criteria…
-
Comments on a specific Row doesn't work, changing comment for one row changes for all other rows
Let's say i try commenting "This is a priorty level 3 task" on a Row 11. Now if I go to Row 23 it shows me the same comment as from Row 11, and if i change it for Row 23, it changes for Row 11 as well. Smartsheet is supposed to store these comment separately and not as same comment for all rows. Please help resolve this…
-
Why can't I choose the auto number column for my report?
I created an auto number column indicating a running matter number sequence for reference in my sheet and need to see it in various reports. I am not able to choose this column for the various reports. Why? Thank you.
-
Calculate average durations between dates
I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am interested in - lets refer to them as an 'open' and 'close' date. I would like to…
-
Nested Formula for At Risk Flag
I've been trying to create a nested IF/AND function. I can get them to work individually, but the formulas are unparseable when I try to nest them. Below is an image of my sandbox where I am learning formulas. Here is what I am attempting to flag in the RISK column: If FINAL DUE is today or in past, AND If FINAL DUE is not…
-
Time calculation formula using an IF variable
I am trying to write a formula that counts the number of days we left to finish specific work cases. The end result that I'm trying to calculate is the number of days remaining to work a second level case based on two variables: 1.) how much time is allowed for a specific case type, and 2.) how much time was exhausted…
-
Suggestion for returning data based on selected criteria
I'm looking for some guidance. I would like a cell to return text (category) based on selected criteria (sub category) -- screen shots below. Example: If I select 'Wine' from the drop down, I would like the Category cell to return 'Food & Bev'. I could do an IF statement, however, there are several subcategories in the…
-
Having trouble with the move function
I've added a column with a simple formula to check a box when a column clears itself of an error =IF(ISERROR([Written number Ref]7), 0, 1) - woks fine no problem, the box gets checked when it is supposed to Once the box is checked I want to use the move function to move the row to a different sheet, however no luck there -…