-
Spreadsheet Filters vs Report Filters
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets making a larger conversion to a list time consuming. I have a request for Report Filters to have the drop down list similar…
-
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
-
Cross sheet formula/reference
Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an accumulation of weekly data that the 6 sheets feed into. Each sheet has a different employee inputting different data. So, If…
-
Report with resource allocation rollup
Hi, I am looking for a solution where I can roll up resources by their allocation at a portfolio level. The resource view only shows me the rollup for licensed users. However, we have users that are allocated to projects that are not necessarily licensed to create or edit sheets. They are ok with read only access. I…
-
Earned value
Is there a reasonably easy way to track earned vs planned value with Smartsheet?
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Enhancement Request: Edit Row from Desktop like App
In a Report, when I select Edit from the row menu, I can see all content in the underlying row, even the columns not shown on the Report. When I do the same from the Smartsheet App on a tablet/smartphone, I only see the columns that are in the Report. I would prefer the same behavior from my browser desktop version (only…
-
Filter default settings
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
-
Help on Formula: if function
Hi all, Please need your help. I'm new to formulas and I've been trying to figure out the right formula for my project status and progress report but I kept getting errors. I have tried the below formula in excel and it worked but not in smartsheet (the smartsheet formula below is another trial I did that did not work).…
-
Will Smartsheet ever support pivot tables or graphs of the data?
Wondering if Smartsheet will support pivot tables or graphs of the data? Would be ideal if this was a widget option in the dashboard views that could be shared with a group.