Conditional Formatting
Hi I am hoping someone might have a simpler solution than the one I am thinking of. I am creating a sheet for my company to track all of our projects. The scope of what we do for each project varies based on what kind of campaign it is. There are 10 different kinds of campaigns, so say for example Campaign Type A might include all tasks, Campaign B might include all but tasks 16-24 etc. The upside is that if a task IS included in the campaign, the calculation for the due date for that task remains the same no matter what campaign. Sorry if this is confusing. There will be columns that Identify a project by Client, Description, Campaign Type and then the next columns on that row will be due dates for each step of the project. My current plan is to set up a formula that says that if the Campaign Type Cell has project type A in it then use the formula to calculate a date, and for the value if false, use another IF function to search for Type B, Type C, etc. Until I get to all projects that require that task. This should work, but given the number of task that are in this schedule (around 40) and the number of campaign types (10) this will take a HUGE amount of time. I was wondering if ANYONE had a better idea. I tried setting it up so that if the Cell contained Type A or Type B or Type C etc. but that didnt work. But something similar would be immensely helpful. Thanks
Comments
-
Hi Brian,
I can think of a few ways to set this up.
Do you want to keep all projects inside the same sheet?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (You can share them too, andree@getdone.se)
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I've got a few ideas myself...
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Brian,
How did it go? Did you manage to get something set up?
Happy Holidays & Happy New Year!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!