-
Countif children row with reference another sheet
I want to count the children rows in another sheet that contain a certain value, my attempt gets an #UNPARSEABLE =COUNTIF(CHILDREN(){Lease Tracker 2018 Manager},="CORNELIUS")) Any thoughts? THANKS!
-
Linking cells to a child cell in another worksheet
I have created a Summary Worksheet to capture high-level milestones from a collection of project plans. The way I set up the summary tracker is to create a parent-child relationship under each project and am trying to link the start and end dates from the original project plan to this summary worksheet. The challenge I am…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
create a project portal with a MS project file
Can you create a project portal with a MS project file (MPP), and update the portal as you update the project file?
-
VLOOKUP - I think?
I am doing estimates for projects. Each job title has its own rate and there are different rates based on specific clients. What would my formula be if I want to reference a particular cell based on these two parameters. They would live on a master rate sheet that could be referenced.
-
Outlook desktop Add-in doesn't work with shared mail boxes
Hello, I have installed the add-in for Outlook desktop but the Smartsheet button in the ribbon only appears on on my User email mail box - when I switch to our shared mail box folder it disappears. This is a big problem as all our incoming orders are addressed to the shared mail box. It works fine across all mailboxes on…
-
ProChain Like functionality
Is there a plug-in type app for critical chain or theory of constraints? I have used MS Project with ProChain and like the fever charts and buffer provided based on focused and low risk inputs. Thanks in advance.
-
Simple method to make a Gantt chart on Smartsheet
A simple method to make a Gantt chart on Smartsheet
-
COUNTIF formula
I am trying to count the number of projects completed between July 1, 2018 and June 30, 2019 with this formula: =COUNTIFS({Status}, ="Completed", {Completion Date}, >=DATE(2018, 7, 1) <= DATE(2019, 6, 30)) The outcome is supposed to be 6, but it is reading back 7 (it is also counting San Antonio). Does anyone know why??
-
Can I add an existing licensed user to my account?
Is it possible to add an existing licensed user who is part of a different existing account to your account and make them a resource viewer?