-
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...?!…
-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
-
Count Number of Open Items in the Last Month by Day
I am trying to make a chart showing the number of open items each day in the last month. In the last month will be flexible so this will be a item that autopopulates the chart as the month goes on. I have a column for the formula =TODAY(-1), =TODAY(-2), etc. to populate the dates for the last 30 days. I have a "received"…
-
Managing Alerts & Reminders
Recently there have been a lot of changes to managing alerts. They have been very good changes. However, today I noticed that I did not receive an alert that normally would come to me. Upon checking I discovered that menus have changed. There is a new heading called "Automation". This took me a while to figure out. I…
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working on building a quotes log where we input a project name in Job Name which then auto fills to the Job Name Master. Next to the Job Name Master…
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…