-
conditional formatting between 2 columns, same row
is there an ability to set a conditional format based on two columns in the same row: completed (column) date is later than the due (column) date – the cell turns red completed date entered is before (or after) today's date
-
Formula for Project Stage & Start & Finish Date
Based on my attached images, I am looking for a formula that will auto fill my Start Date when my Project Stage = "Scheduled" and populate Finish Date when Project Stage = "Invoiced". Any help will greatly be appreciated. Thanks.
-
Formula help for new user
Will anyone be willing to help me with formula in smartsheet. I am new user and have lots of problems I would like to sort out. But let me start with the most urgent. I have column 1(SA), 2(SB), 3(SC), 4(ST) and would like to have column 5(CLIN) be filled based on column 1,2,3,4. When column 1 will show number (price) than…
-
Date Formula
I looking for help on a formula that will SUM the column by month. So when I go into a new month, it will sum only the month we are in since the column represents all months of the year. I have a supporting value and formula sheet that host these values and are linked to my dashboard. I currently have to edit reference the…
-
SUM formula is not working?
I am using form to add row (data) to smartsheet, But newly added row on the top of smartsheet is not included in autosum at the bottom of smartsheet. How I did it was went to the cell at the bottom I wanted to see SUM and highlited cells from bottom to the top. Rafal
-
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
-
CountIf's with a date
Hello- I am trying to get a formula to calculate if the task is still open and the date is before today's date then the task is overdue. This is what I have for the cell and it keeps returning unparseable: =COUNTIFs({NITD Action Log Range 2}, "Open", [{NITD Action Log Range 3}, <=TODAY() ] Range 2 is a column stating if…
-
IF FIND RIGHT String
Hello, I’ve been searching all over the Smartsheet community since last week and was hoping someone could offer some assistance. I have a long Status value that I need to auto populate a shorter value in another column. I really just need a contains formula but I haven't seen that as an option here. I could do this for the…
-
If function
Please can someone tell me the formula I need if a box is ticked how to move an amount to a different column. so If mikes ticks is ticked how can I move the amount to amount outstanding. thank you Sue
-
Risk Status on my Smartsheet using formulas
I am using Blue, Green, Yellow and Red for my project status - I have a formula around it that will change the color accordingly. What I want to do is if the color ever turns Yellow or Red log it as a risk in another column. I can get it to work but if it is ever a risk I want it to remain a risk even if the task turns…
