Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect a…
Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no lo…
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown belo…
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of pro…
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified …
I have created a Customer Satisfaction Survey with 12 questions that use a 5 point Likert scale. (Strongly Agree / Agree / Neutral / Disagree / Strongly Disagree). I have tested the web page and it al…
Hello, I have a sheet where I want to add totals in 7 other sheets for January - December for several drugs. When I get to February, it tells me I am at the max for references. I think it was 15. We h…
Is number positioning/formatting available on bar graphs in a dasboard?....any chart? My numbers all overlap and I can't figure out how to clean it up.
Hi I'm trying to convert an Excel formula to Smartsheet formula: Excel formula =[Installation date]4+(365*[Warranty Expiry]$3) Aim is to give a future date when the warranty will expire x years after …
Looking to assign a % complete to a project based on days from open to estimated close. Have a column showing total network days from these dates and now want to either nest a function to subtract the…
