-
Auto group like cells
Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).…
-
Is there a way to prevent users from moving on to next cell...
...without entering a value in a particular cell? For instance, I want to make sure that users enter a ZIP CODE is a row - If they do not, I would an error/warning to pop up or, at least, inability to save the entry without entering the ZIP. Any suggestions?
-
Alert when adding a new row
Hi, We have a sheet where we keep track of current statuses of our clients and this act as a mini project management tool for our clients. Each client is in a row and the stages are indented underneath. We would like to create an alert to notify specific persons everytime a new client is added, and this we have done it by…
-
Identifying Current working Task and it's Parent
Good day! I've been reviewing quite a number of ways in finding the current task, last completed cell in a column, etc etc and cannot get what I need to work. I've attached screenshot with the data in my sheet and I'll provide the formulas below. What I'm after is looking for the last non-blank cell in the Status column,…
-
Charting cell values over time
Hello, We are using the smartsheet as an interactive issue resolution tool in a workspace environment where each project has its own smartsheet. We have the dashboard set up which pulls key data points we are aggregating within each smartsheet (ie number of open issues, how many are high priority, medium priority low…
-
Anything like pivot tables?
Is there anything similar to a pivot table capability in excel? I am trying to graph and analyze text - not numeric values. I figure I can make a secondary sheet in which I can do the formulas I need but I was trying to figure out a way to do this with minimal upkeep.
-
Postpone the start date of a project
Hello Community members, I want to extend the start date of my project schedule(Gantt chart) by 2 weeks. I have no dependencies and I just want to statically push the dates for all tasks by 2 weeks. Can this be done in smartsheets. Appreciate your help. Neeraj
-
Embedding Tableau Public link to a dashboard
Hi there, I'm currently operating on an Enterprise level version of Smartsheet and experiencing an error with my dashboard. Does anyone have experience embedding a Tableau Public link directly into a dashboard via widget? I see that this is an option and have tried both the link & embed codes, which both return the same…
-
Time Tracker
I am having my team track their time. I have a column for a start time and end time. Right now I am using military time )0 to 24 but I would like to know if there is a way to use normal time so my team can use 1pm to 3pm.
-
Automation
I have a sheet which has all of the training details of people who work for us. Previously I have set an action every week to email people whose certificates have expired to remind them to send me their new certificates. I want to use the new automation function to do this for me, however I can't see how to trigger it...?!…
