-
Cross-sheet formulas
I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there. I have a couple of questions about the best way to use the new…
-
Recurring Reminders
Hello and thanks for any assistance on this! I'd like the ability to set automatic recurring reminders for my clients. The ability to have a column "Follow Up" with a drop down menu showing 2 weeks, 1 month, 3 months, 6 months,etc... and then have an email sent to me every 2 weeks or whichever was selected. I'm ok with an…
-
delete this post
delete this post
-
Pasting hyperlink cell from Excel no longer working
Until today, we were able to copy a cell from Excel that had a hyperlink, and paste it into a Smartsheet cell and it would maintain the hyperlink. This has stopped working today. It pastes the text, but not the hyperlink, and this is a critical component of our workflow. We use Chrome as our browser and have never had this…
-
Master Schedule
We have a a master sales information sheet that imports from our sales software and then links out to individual client sheets. Each of the the client sheets links to the previous job via cell linking and predecessors, We then have a portal that includes a gantt view of a report that we look at for scheduling - see…
-
Sum of each different categories in on one column
Hi, I have 2 columns, one with a product description(Different products on a 1000 cells) and the other column it is their individual value. May you assist on how to get a sum of, say "shirts" only from the product description column?
-
Dashboard Chart Formatting
We are creating a dashboard and every time we re-select the Chart source data, the formatting of the chart reverts back. Why do we have to reformat every time? Screenshot of the chart:
-
SMARTSHEET USER MANUAL
Hey Has anyone compiled a 'user manual' for collaborators who has never worked on Smartsheet? Our company is within the construction project management sector and we collaborate with many consultant. At the start of each project we need to provide Smartsheet training, specific to our project sheets, for the consultants. I…
-
How to print without Conditional Formatting?
I have a sheet with a lot of conditional formatting that must be printed in the gantt view without any of the formatting. So each week I have to disable all the rules, print, and then enable them again. It's tedious. There must be a better way. Any thoughts on how I can generate a gantt in a PDF without the rules and…
-
Approval Request with multiple approved or multiple declined
I have a project approval workflow performed in this way: If it is Accepted, then if accepted as Lightweight project then save status as "Approved as Lightweight", else, save status as "Approved as Leverage"; If it is Declined, then if Declined due to lack of resource, save status as "Declined due to lack of resource",…