Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER …
Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't ha…
I need to report a GO Live date on various dashboards. The problem is the go live date is not in a static row and can move up or down in the project plan based on tasks. I assumed that I could use the…
What I'd love is for an assigned task to create a new Planner task and be linked together when changes happen to either side they update each other. Primary use case is that the majority of people who…
Can I change the heading of an automated workflow email so it does not look so much like spam? I would prefer it to look like I sent the email and not the automated system.
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inabili…
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally…
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a 0.5 story point = 1d, 1 story point: =2d 2 story poi…
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is f…
Hi, I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out? =COUNTIF(CHILDREN(), 1) + "" returns the count of checked boxes. =(COUNT(CHILDREN(), 0) + "" returns the count of…