Angie Hatfield’s Profile

Community member since April 2016

National Auto Care
Project Management
How I Use Smartsheet
I use Smartsheet for anything that needs to tracked by multiple people, for anything where I need to gather data, to generate and auto-send reports, for project tracking, general lists, and a multitude of other things. I also create them for anyone in our Company who needs to track something. We have a love/hate relationships with it. It is very useful and widely used, however we use it so much that sometimes there are groans when an update request comes across someone's email :).


Alerts, reminders, and requests

  • Create and manage manual reminders for other people
  • Create and manage manual update requests
  • Create and manage automated alerts and reminders

Does this mean that any time someone wants to be alerted about a change, etc, that only a licensed user can create them?



I have the following columns and need to return the value of something from a date through the end of the year. 

1. Est Mo Contract Count - A number

2. Ave admin - Dollar Amount

3. Estimated Value - 1 x 2 

4. Start Date - Start Date that 1 actually goes into effect

5. Weighted Value - Sum of 4