Sign in to join the conversation:
Hi! My Project intake sheet says #Blocked in the Schedule At Risk section for one of my projects. It is preventing it from showing up on the dashboard as well. Any ideas what may be wrong? Thank you!
You will need to look at the source for more details. Where is this data coming from, and how exactly is it being populated at each step?
I submitted the info through the intake sheet and it popped right into the intake sheet. I connected it to the project metadata sheet, but the schedule health isn't "connecting" like the one below. I did the same thing as the one below. Where do you recommend starting to go through each step?
I would start by looking at the metadata sheet and seeing what is going on in the cell that you have linked in.
On the Project Intake Sheet it says the "Schedule at Risk" is linked to "Project Metadata" and vice versa when looking on the Metadata sheet. Are they linked to the wrong things. It says the same on the project underneath, but the schedule health is showing. Sorry, clearly not a frequent Smartsheet user!
Are you able to provide some screenshots?
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
