I'm not sure if what I want to do is feasible or not so please let me know if I'm going off the deep end. I would like to have a Harvey ball change color based on several criteria/variables to show li…
Greetings: Trying to create a formula that tracks task duration displayed by "symbol" in conjunction with another condition of the task:... complete, or not started. I was able to get the symbols to s…
Hi, Can anyone assist me, trying to use a simple formula =MAX(IF(Max2418:Max2419 = "YES", [Column14]2418:[Column14]2419)) however Smartsheet says its invalid, I've tested in Excel and it works fine. J…
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 c…
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 ba…
* 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…
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 wor…
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 da…
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 …
