- Countifs statements for date fields that are in the past
Hi there, I am looking to summarize data from a master sheet for inclusion into a dashboard via a project metrics sheet. Within the master sheet I have an “Opening Date” that is populated when the opening date is decided. I want to populate the Dashboard with the number of sites that HAVE opened each month (past tense).…
- Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
- Finger gesture scrolling.
We issued Surface Pro 7+’s and Surface Pro 9’s to managers to use in the field now that Smartsheet has become the main system for work orders and assignments. For some reason, when using the browser or app on these devices, we are unable to scroll by touching the screen and swiping up and down or left or right. We can…
- Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
- Conditional Formatting Primary Column Indention
Is there any way to indent specific rows in the primary column that meet a specific condition, like through conditional formatting? For example, WBS ID is the Primary Column. I would like to indent that row if the Activity ID is not blank. It appears that the only way to do so is manually indenting/outdenting.
- CountIF / IsDate combination
你好我想公式链接到count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well. Thank you in advance.
- 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…
