-
Formula changes without showing in Activity Log?
I have this formula: =IF(ISBLANK(Location@row), "", INDEX({Location_code_helper Range 1}, MATCH(Location@row, {Location_code_helper Range 2}, 0)) + "-" + RIGHT(Year@row, 2) + "-" + COUNTIFS(Location$1:Location@row, Location@row, Year$1:Year@row, Year@row)) It basically creates a custom identifier that uses the year and a…
-
how do I add a calendar view in a Dashboard?
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them to have any any interaction, just see it as a reference. Is this possible? Thank you. Jef
-
When will printing grouped reports be allowed?
This is a game changer for us, and we are sitting idle. We are examining other software that allows this functionality. This is critical for adapting to our changing business environments. This seems basic. I know it's not. Are there any updates? Thank you
-
Reporting Earned Value vs Planned Value for SPI Metrics
Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that include start/end dates, duration, dependencies, and % complete. We do not resource…
-
Cash Flow Forecast
Hi, Is there any way of doing a cash flow forecast/projection within Smartsheet. With most other project management software this is a built in feature. I would like to do a forecast of the monthly projected cost for the project.
-
RFI / Submittals Tracking Template
Hi all! Wondering if anyone has a good RFI / submittal tracking template they are willing to share? Having trouble formulating the best tracker myself as this information flows really quickly. Thanks!
-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Pre-populate a form
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change control log.
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
-
Index Match or Index Collect with multiple criteria
I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row, {Scope of Work}, [Scope of Work]@row)) Solutions? 😁