How can I identify the hex color code for the cell fill options? I want to write an IF statement to return value of 1 if the hex color code is the darkest blue (as an example). A little background....…
I am new user to Smartsheet and I am trying to figure out a formula that will calculate a date for a question like "What date is the 3rd Monday of a given Month". Through some google searching I came …
Hi. We have a calculation that will total various costs based on a manager. It works fine if we only need to include costs for a single manager. However, it doesn't work if we want it to total costs t…
Trying to get RYG symbols for % completed on tasks. I am getting #UNPARSEABLE =IF([% Complete]4 = "100%", "Green", IF([% Complete]4 = "50%", "Yellow", IF([% Completed]4 = "0%", "Red", " "))) Can anyon…
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my…
Hello All - We currently use a smartsheet pipeline to track our clients progression through our service delivery. This serves us very well. One area that we need help with is scheduling and tracking p…
Over the course of a contract, I want to track how much has been invoiced and how much is left. If possible, for some contracts I know the invoicing is on a cycle and should be the same amount on say …
Hi all -- just starting to build a library of IF statements... Looking for some help to build an IF statement to determine which Sprint is the current active sprint... Basically, IF Today's date is be…
It appears as though you have to open a sheet for a formula to run. Is this correct? I have reports that show out of date data due to the sheet not being opened therefore causing the formula to activa…
