Email address (mailto: link) in Dashboards
Hi - Have there been any updates on being able to enter an email address (mailto: link) in Dashboards. I would like to add Key Contacts for the project in a Rich Text Widget and include links to emails for those contacts. I've tried but have not been successful. Any possible workarounds? Thanks, Jan P
Status Change Formula Unparseable
My sheet requests dates at certain milestones which should change a status from 1-10. My formula is not working and I think it is likely a syntax problem. Can someone assist please? =IF([10. Date of Closeout (Kayla)]@row,"10",IF([9. Date Invoice Received (PM)]@row,"9",IF([8. Date RR is Received (PM)]@row,"8",IF([7.…
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…
Why are most of my months showing up "N/A" when I know there is data?
Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
Pasted text from OneNote to Smartsheet cell appears as an image?!
Hi, When you paste text from OneNote into a cell in Smartsheet it appears as an image. This is so annoying. See attachment. The only workaround is to paste the text into a web browser or word document, then copy/paste that back into Smartsheet cell. This is affecting our use case somewhat, as often in project meetings our…
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…
Parent row status formula based on child rows
Roll up formula for status I have this formula (shown below) where I am trying to get the status of the parent row automatically entered based on the child row. I'm not sure if I've stared at this too long and my eyes are crossing, but it's not doing what I want it to do. I think I've listed all the permutations below. 1.…
Help using the NOT formula
Hello! I'm trying to write a summary formula to count how many projects have a Resourcing score of 8 or higher and the approval status is not "canceled." This is the current formula I'm attempting: =COUNTIF([PM Resourcing Score]:[PM Resourcing Score], >=8, AND(NOT(CONTAINS("Canceled by Specialist Team", [Approval…
Help with Index Formula
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the data I need for this one item. I want to calculate how many strategic projects vs. KTLO projects a team has for the…
How can I link predecessors from one sheet to another?
A task in sheet A is required to be completed before a task in sheet B can be worked. Is there a good way to do this? Note: I also have a master sheet that is fed from the values in sheet A and B combined. I want to be sure the integrity of that link carries over into our master sheet. Thanks!