Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Proj…
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so w…
I have a milestone date in my timeline (0 day duration). I would like to link it to a predecessor that is currently scheduled to finish a few days before the milestone, however, when I add the predece…
Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easi…
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, t…
Am I missing something? I've been trying to push the start date of a project from the intake sheet (via intake form date input field) without success. Upon spinning up the project in SCC, I get the er…
Very curious about this Ancestor (aka parent) and Child Blueprints under one Program.. - I think it would really help our Program, as we need to work off of a "master" project number list which can't …
We have a data base of Subcontractors, that is created in a sheet. I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor. I have a column …
How can I get columns unchecked automatically when they meet a date criterion? For example, all tasks checked today will be automatically unchecked tomorrow because the calendar date has changed.
I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOK…
