Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using Today Function to display certain Cells
I am working on a sheet for salesman to use to track their sales, while setting up reports for our manager to be able to check in and see the YTD sales goals. What i am wanting to do is set up a formula that will show up in his report for him that will show a cell only if the date is Within th month.
If the month is June i need it to display june in my YTD Column
When july comes i need it to automatically display the percentage for june.
I was thinking of chaining an IF function that says "Display June YTD % IF the month is June. I need it set up so if it switches to July it will recognize in the formula it is july and change for me.