-
Formula errors
* Schedule Variance:* Getting errors Invalid & Unparseable. * My best guess to those results. Are the other columns that it's looking at have cells that are blank. ( actual finish date) resulting from the fact that that task is not completed yet. Thus nothing to draw from * What I’m trying to have the formula pick up...is…
-
Count ifs?>
Hello, I created a form and now have all the data i need. However My formula to give me the number of each tea that was voted for has to be accounted for. It seems that my countif formulas are not working correctly. Can anyone help me?
-
Keep users from back-filling completed dates
is there a way to set a date column so that only the current date can be entered? Right now we have START, DUE AND COMPLETED DATE columns. The problem is that people are back-filling the completed date, for example putting in a 3/1 completed date on 4/1. We would like to get people to fill in the completed date on the…
-
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…