-
Can a column/row (box) be linked to a specific day within a timeline range?
We currently use grid where each box/column in a row is a day and each box is a color that is associated with a stage in the process. It's a make shift gantt that's not idea for updating when the actual timeline changes. I'm hoping that we can create a similar sheet in smartsheet where it links to timelines and adjusts…
-
how to create auto populated date column?
How to create an auto populated date column? we have a tracker of requests, we want to get completion date auto populated in very next column, once we tick the checkbox on "Done" column.
-
Countifs Multiple Criteria
I am trying to count multiple criteria. For example, here is my formula: =COUNTIFS({ALS Resolvion Claims Tracker (INT) Range 1}, "ART Asset Adjusters" or "Paramount Recovery", {Client A Claim Tracker (Internal) Range 1}, "NOT STARTED") When I put in the "or" and "Paramount Recovery", I get an error message. Please help!
-
Formula with date and price linked
I have 3 sheets. One is a master sheet with training expiry dates (Master Recency), then I have a training budget, monthly, and a pricing sheet. The training department updates the Master recency sheet with the dates training will expire. I need the training budget to look at the master recency sheet. Take the renewal…
-
Why "Assigned to" drop down list shows 4 contacts only?
Why "Assigned to" drop down list shows 4 contacts only? I had 6 contacts in total, can it show all the contracts in the drop down list? Million thanks!
-
How to automate the RYG status balls
I need help to automate the RYG status balls in the "Status" column, depending on the "% Complete" for each request. This is my formula but it kept showing "Red" though I have % Complete is 75% and 100% =IF([% Complete]@row < 70, "Red", IF([% Complete]@row > 70, "Yellow", IF([% Complete]@row = 100, "Green"))) Requirement:…
-
Sumif function?
I am trying to figure out which equation to use. I would like to Sumif from one sheet (Sheet A) to another sheet (Sheet B) as a column formula. example story I have a column for “strain name” and “batch number”. Each batch # will consist of one strain, but there will be multiple buyers per batch. Each batch can have…
-
Counting rows of a date column 90 days from today's date
I have tried this formula below to count the number of rows in a column that are 90 days from today's date but what it calculates does not match when I manually count the rows in the source smartsheet. =COUNTIF({BDPM - CURRENT PROJECTS Range 5}, >(TODAY() + 90))
-
Moving From Airtable to Smartsheet - "Link to" equivalent?
Hello community - long time listener, first time caller. We're considering a move from Airtable to Smartsheet and looking at how to migrate some of our more complex tables. We have several tables that use the "Link To" field type, which allows you to select one or more values from another table. Essentially, you identify…
-
I need help on a multiple IF statement formula
I'm struggling to think through the logic to allow for the required scenarios. If the row is a master row - leave no flag as not at risk If the row is a 1st level sub heading - leave no flag as not at risk If the task isn't started by the start date = at risk! If the project has started but the review date is in the past =…