-
Greyed out baseline tab
Hi, I'm trying to make use of the Baseline function, but it's greyed out. I'm in the Gannt View and also the owner of the sheet.
-
Form Fields Out of Order
I have created a form with with about 30 fields. I have set up some automated update requests. When the person receiving the update request link opens up the link to the form, all the fields are not in the order I set them up in. Any ideas what has happened here? Thanks, Jay
-
Any formula, if duplicate, say: "Duplicate"?
Any formula, if there's a duplicate in this column, say: "Duplicate"? Thank you!
-
Using decision symbols: Yes, No & Hold
Hi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following parameters: If [Status@row] is equal to "Submitted" or "In-Progress" and [Created@row] (date)…
-
COUNTIFS using Dates and IFERROR
I'm trying to replace some formulas in a summary sheet that I accidentally wiped but I cant seem to get them to work and I know I'm missing something but I'm not sure what. What I'm trying to count is all the dates listed in the year 2020 from another sheet. However, some of the rows in that column are blank. The formula…
-
IF Function Question - Symbol changes with date
Hello, I have been having some issues configuring a formula in smartsheets. I am trying to write a function where the Symbol (Green, Yellow, Red, Grey Balls) in the 'Status' column adjusts according to date in the 'Start' column. Green appears if the start date is 7 days in the future or beyond Yellow appears if the start…
-
Creating Color Coded Column
Help me out here guys... I am trying to create a color coded formula that would produce the following results: If date file received is not blank – populate green. If date file received column is blank AND….. If today’s date is 1 day older than expected date column – populate yellow If today’s date is 2+ days older than…
-
How do I make cell references in formulas dynamic in Smartsheet?
Cell A must be the average of cells D11 and E11 of the different SUCRIVOIRE-BOROTOU-KORO and SUCRIVOIRE-ZUENOULA sheets. So within A we have the formula = AVG ({reference of D11}; {reference of E11}). How to ensure that by copying or duplicating the formula from cell A into cells B and C, on the SUCRIVOIRE sheet, we…
-
Function for looking up data in a range and display "yes" or "no"
I'm trying to pull some data and can't figure out which formula to use. Here's what I need: I have a unique ID in my master database. In this same database, I also have a Budget 1, Budget 2, Budget 3 (the budgets are each in a separate column) for each unique ID - see example screenshot (first 4 columns). I am now pulling…
-
Attachments within the proofing window not downloading
Hi Everyone, My team members are having issues with proofing tool. Within the proofing window, if they try downloading any attachments, they are receiving an error, as attached. When they click on the proof for any assets, the proofing window opens up with the very first version, and not the latest version. The team has to…