I would like a formula to tell me the number of days holiday taken this month

Options

Answers

Paul Newcome ✭✭✭✭✭✭

04/09/20
Options
Yeah. Sorry. the best thing I can think of is the helper columns on the source sheet then a SUMIFS kind of thing on your Metrics Sheet. Sorry I couldn't be of more help.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
Joachim Mund ✭✭✭✭✭✭

04/14/20
Options
Thanks Paul for your time and help.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…
Alerts when X ammounts of items arrive for project X
Backround: I work with custom computers, its only me myself and i in my department so i am looking to automate as much as possible. I have a sheet where i enter every part that arrives and which Project number it belongs to, what Serial number the part has and the parts EAN code. Goal: I would love if i could set up a…