Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?

Hard to explain just in the question box.

We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type of formula or function that would allow us to type an employees name in next to the project name and will also remove that employee from the employees available portion of the sheet (see attachment).

This may not even be possible. I have a feeling we may manually have to do this, but wanted to see if anyone had experienced anything similar. I thought about the Replace formula but we aren't taking names from a different sheet so I am unsure if that would work or not.

Any help an/or advice would be much appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!