-
Quickest way to create a new sheet from a template?
I can't remember exactly how I used to do it but I'm sure the old style smartsheet was easier than trying to do it now. We hadn't been using it long before the change. The process I'm currently using feels extremely cumbersome. Please tell me what you've found to be the quickest/easiest way to create a new sheet from a…
-
Keeping old and new data when needing approval/decline
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent both forecast and actual money spent per month (two separate columns per month). When a product owner adds a forecast amount…
-
Open enclosing folder or workspace
When I am on a sheet view, how do I go to the enclosing folder or workspace?
-
Publish a shared google Calendar in a sight
Hi there, I've imported our team google calendar into a smartsheet no problem, and I can see all the entries, however when I try to present this in a sight the calendar grid is displayed without any entries. I've 'published' the source sheet with the calendar import, and both the source sheet and sight are shared with all…
-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
Keep child rows collapsed to the parent row at 100% completion
I like to collapse my rows to just see the parent row when the child tasks all reach 100% (I don't want the rows to to be removed from the report - I know it's an option not to display them when they reach 100%. It seems that, when I collapse them manually, some or all of them are open the next time I open the sheet. I…
-
Unable to edit smartsheet items in Microsoft Teams
Hi all, I have a client that uses Smartsheet and will be joining our Microsoft tenant shortly. I created a Smartsheet account to familiarize myself with it and connect it to Microsoft Teams. I've created a tab and connected a sheet/report and it's showing me (View only) on Teams unable to edit. I granted a co-worker Admin…
-
form data capture
I am collecting daily sales totals and transaction totals with a form. The store manage enters the totals into a SS form daily and it populates the SS. I would like the entries to sub total into months as they are added to the SS... then those monthly totals can roll up onto a dashboard, along with other department…
-
FEATURE REQUEST: Auto Update
I've been working for the better part of a month on integrating smartsheet into my department at work. The ONLY issue is that we have up to 8 people editing the same spreadsheet at one time. Some of us might write on 3 lines in a row within 30 seconds. I need other people in the department to be able to see what lines are…
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…