-
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…
-
#CALCULATING Displayed instead of Qty of Days
Hi All I'm looking for some advice. I have an IF statement that provides me with a count down till production starts for each product, and this has worked well for many months but is now becoming unreliable. Most of this data is pulled from other sheets using VLOOKUP. It will display the count day for 10 mins or so then…
-
Why are Round function irregularly displayed in dashboard
When I use a Metric widget in a dashboard, add data (Rounded) from a Grid is sometimes displays the rounded numbers, but the next, without modifications, it doesn´t.
-
Automation: Copy cell value to another sheet
Hi, not sure whether this has been answered yet but my question is as follows: I have a sheet, Sheet A, that stores all the projects and their information, such as Project ID, project status. I have another sheet, Sheet B, that stores only projects that have reached a certain stage (ex. in execution). And I just want to…
