Discussion List
Course Delivery Date formula
I have a formula that seems simple, but for some reason it's calculating an extra day. There are three columns and the first is duration in days, the next is delivery date, then the third is the end date. What should be happening is the delivery date should be counted as one day, then the calculations should be added to…
COUNTIF functions returning 0
I am trying to create a countif formula that references one other sheet. I want it to pull with 2 different criteria if the column = 01 and the second column = "open". =COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, "01", {Dump: OPEN AND CLOSED REQS Range 2}, "Open"). This function returns 0 when I know there is a few that…
How can we have a drop down in Dashboard
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks
How can i have a report widget that tracks Smartsheet user's daily activity?
such as amount of changes made by one user for the day. I know we can track this in activity report but i need something that is immediate.
access to the dynamic view dashboard
How do I get access to the dynamic view dashboard as I have a Client trying to share a worksheet with me? Thx
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
How to set a members availability to specific days
Some of us work 5 days a week, others only 1 or 2 days a week. How is availability set for each member? This seems like an basic feature. Does it exist? If not. then I have no idea how to use Smartsheet for part-time members.
Formula to collect column names if there is a "1" present
I have a pivot table that I am attempting to use in order to collect a list of all jobs that our subcontractors have/are working on. Basically, I want a roll up of all jobs that each sub has worked on. The sheets where this info is held are all on individual sheets, which is the reason I used a pivot table to try and get…
Group Favorites into Folders
Once you have identified your "Favorites" can we get an option to group / organize them into folders please? Thank you
Sheet Statistics
Something that quickly shows # of rows # of columns # of cells # of cross references # of unique formulas I'm sure there are other metrics that would be nice to see quickly Close to breaking warning or notification to sheet owner Could be part of Work Insights but all together, like a table, and update immediately.