Is this possible?

Is it possible to have a space sheet where the locations are housed.

Then when someone selects the location and submit how do I make it so that if that location is showing for that month of submissions that they are reporting and if their location is not any of the submissions for the month how do i show them as not reporting for that month?

is this too complex?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!