Formulas
Discussion List
- Hello, How do I calculate a person's age from their birthdate?
- I'm making a training matrix for my company. Source sheet is the "matrix" that will list all employees and their required trainings: *RowID is auto-numbered column *RowNo formula is =MATCH(RowID@row, …
- Hello! Quick question I've been stumped on. I have a sheet that tracks hours worked on different projects each month in a year. I want there to be a cell that displays the average of the most recent 3…
- I need to pull in all of the email addresses from a sheet into another sheet so that my workflow can alert the people listed in that cell. I have the cell set up as a contact list allowing multiple co…
- I have a sheet where people are picking up open assignments. This is being linked to the master sheet with the Parent and children tasks. I am trying to figure out how the "pick up assignment" can aut…
- I need a formula for a duration of days between 2 date columns. I have no idea how to do this, as I am a new smartsheet user and not familiar with coding or formulas. Any help would be GREATLY greatly…
- Hi! I have created a sheet that uses a form for requests when my company is wanting a physician to travel. This includes what center/state they're traveling to, their home center/state, the district m…
- Hi, I have a SUMIF formula which currently looks at column 4 and if it contains X, it sums the figure in column 3. I now need to take the total and multiply by 1.2%. Have tried a number of ways! Any h…
- I'll try to keep from getting too convoluted. On my main sheet I have a "Start Date" that pulls a date from another sheet. I have built a long checklist of items that are due based on this "Start Date…
- This is a complicated one that I once got to work with RGY balls, but cannot figure out how to apply this to the Pain scale emojis. What I am trying to do: (Using the pain scale symbols) Have symbols …