-
Formula to Flag or Not Flag
Goal: Flag when the due date is in the next 7 days No flag when the due date is BLANK or more than 7 days in the future Two formulas that seem to work separately: =IF(Due Date2 <= (TODAY() + 7), 1, 0) =IF(ISBLANK(Due Date2), 0) Anyone know how I can combine these formulas to make both work?
-
Automation in Portfolio Rollup Sheet Not Working Properly
I have a portfolio rollup that is exclusively made up of cell links from all of the metadata sheets from the various projects we are tracking. In an attempt to remove the complexity of managing the project I wanted to automatically archive metadata lines from the rollup via automation. An example of the process flow is:…
-
Red Flag If Statement and Children function
Hi All, first of all, I am new here, so thanks for every help in advance. I did do some research in the forum and tried to figure it out myself, even trying to adapt similar codes to mine, but just couldn't figure out a solution that works. I have a "Task at Risk" Column that shows a red flag when the task will be do the…
-
When creating several projects in Smartsheet, how can I see all the projects in one calendar?
I would like to understand if Smartsheet can help in scheduling pur production runs? How can I see all of projects on a calendar that is sharable with our team? Based on phases, or certian items that are part of the worksheet?
-
Trouble with Project Management & Smartsheet Restrictions
I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome these issues without having to turn off all dependencies. Without dependencies the product doesn't offer much for project…
-
Weight of a Category in my Construction Project Plan
Dear Colleagues, If anyone has come across this requirement, please share how to solve it. I have various categories in my project plan: Indoor Works, Outdoor Works, Testing and commissioning etc. Each category like that has a weight in a project. My colleagues who are already using the plan have manually filled in the %…
-
Auto populate based on entry in another column
I have a column "Actual Status" that I'd like to auto populate based on the "Planned Finished Date". Can anybody help please
-
Card View for Reports!!!
PLEASE PLEASE PLEASE provide a card view for reports. Our business has a master sheet with course construction responsiiblities for a plethora of individuals. I have been trying to teach managers to use filters with card view to only see their users and thier tasks. But there are so many aspects that are confusing people…
-
Notifications for Contact List Column Option
Just wondering if the notification for contact list within a column setting has been resolved and we can now get notifications when something has been assigned to us?
-
Column Highlight
is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.
