MattH✭

Mike, this smartsheet help article explains everything you need to know about working with cards within card view much better than I could: https://help.smartsheet.com/articles/2449494-card-view-creating-editing-and-sharing-cards The short answer is it's possible to show/hide fields on a card. The above article will help…

我只是想当添加n I'm working internally with teams to help them build their own processes with sheets that's often the only reason they refuse to use the "comments" on a sheet: they'd rather use a single cell to see the latest update and suffer later if they need to review the whole history.

This question is very broad and you may want to pay for consulting services. However, I'll respond with an answer that's just as vague. First, identify your process (who is doing it, when are they doing it, how often are they doing it, does it ever get reviewed, what you're going to do with it, etc). Second, identify how…

Using (SUMIF(Month([FinishedDate]) = 1, TurnAroundTime:TurnAroundTime)/Countif(Month([FinishedDate]) = 1) This will add all of the turn around times and then divide by the number of projects that finished in that month. You'll need to get fancier if you need to look at year, but then you just need to use SUMIFS with Month…

Use empty quotes. Like: =IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", IF(ETA11 = "", "Yellow", ""))

Mike, if the frequency for an update request to say weekly, wouldn't the recipient receive an update request weekly regardless of whether or not the update request was updated the previous week? Or am I misunderstanding?

You would use a nested if statement. =IF(Column1, ="Not Started", "Yellow", IF(Column1, ="In Progress", "Blue", IF(...etc I strongly recommend that the status is a drop down so that the formula never misses a typo.

I don't think you'll find any disagreement with that here. Recently, at the ENGAGE conference, even Smartsheet employees expressed frustration with how this currently behaves. At the right, there's a "Submit Product Enhancement Request" link.

Take a look at this post: https://community.smartsheet.com/discussion/countifchildren-criteria

I'd investigate using update requests that refresh on that cadence. As far as I know, there's no way to automatically "move the date" when a task needs to be done next; however, update requests, I think, should bridge the gap in that functionality.