I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute).
I tried searching the boards, but not sure that I'm asking the question the right way. Essentially, I'm looking to know the following:
Within the Smartsheet worksheet, I have two columns both set up in a checkbox format. I'd like to restrict my users from checking both accidentally as it should be
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed
I want Wednesday as the weekof based on the date
for e.g. If cell A has date of 25th Nov, the weekof in cell B for that date should be 20th Nov
If cell A has date of 27th Nov, the weekof in cell B for that should be 27th Nov
If cell A has date of 26th Nov, the weekof in cell B for that should be
I currently use reports tied to a central tracker to report out project updates to several different teams. Some of these projects require sharing of attachments and conversations about those attachments using the row's conversation tool.
When individuals are tagged in these, the auto-email to
I am desperate for some guidance on the best way to handle my situation.
First, I have 2 sheets that I'm attempting to provide an executive view for:
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want:
If one of the dependencies has a red color ball, I want the parent ball color to be red.
If all dependencies have a green ball, I want the ball for the parent to be green