Hi I don't seem to be able to affix any text to =PARENT()? I want to have each of 6 child rows as: =PARENT().01 =PARENT().02 =PARENT().03 =PARENT().04 =PARENT().05 =PARENT().06 Any thoughts? Thanks Ch…
Just to be clear I only have one end date in my sheet. The sheet has a conditional format set up to flag "At Risk" tasks when the end date has already passed. Here's the current formula: IF(AND([End D…
I want to be able to see the count of Projects that are assigned to a specific person in one column and have a status of complete in another column. Not sure what I'm doing wrong? =COUNTIF({Master Tas…
Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solutio…
Is anyone having issues with rules and being unsubscribed? With the smartsheet (server side) issues over the past few weeks, i've had a ton of sheets to re-do all the rules on because there is no glob…
Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful…
Let's see if I can properly explain my question! I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. …
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an '…
Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See att…