-
Multiple Stacked IF formula with OR function
I have got a column called [Status Code] which has a single letter between A-J in it. I then have an adjacent cell where I want to return a specific name depending on which letter is in the previous cell. However I have tried various combinations and cant seem to get it to work. It is nearly there but still erroring. I…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
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