-
Which formula should I use if I want to add up all values from a column?
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these values are apples, bananas, oranges, pears, etc. I am not looking for the total of each specific value, I want all of the values…
-
Copying Workspaces with Dashboards
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Currently we have to go into each dashboard and update the links - very tedious. We are using…
-
Friendly Reminders
Hi there, I have two troubles with the tool, I hope you can help me and I'll grateful for that First: I'm automatizating my process with friendly reminders, but these one e-mails their looks like a spam e-mails, I mean, the vowels with tilde doesn't recognize it and show a question mark in that space, this action it's…
-
How to put formulas in smartsheet form without it automatically override as text?
When I use an automation workflow from a form question hidden as I have the formula as the default value of that question, how can I get it to work it's formula instead of it overriding as a text? So when I put in the formula in the default value in the form and when after the form has been filled, the formula is exposed…
-
Formula-Reference another sheet and see the column rather than(SheetName Range #)within the formula
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Contact Month], "Jan", [Point Person]:[Point Person], "Mark") I have another sheet named "Summary - 2020". I want this exact…
-
Version Control
Does Smartsheet have a type of version control?
-
Customized Buttons in Dashboard/Portal
After seeing very nice dashboard presented in Best in Class Project Management video I tried to start developing something similar for our organization. However I'm struggling with creating customized buttons (like "Home", "Portfolio Dashboard", "Departments" etc) that you can see on the top of the dashboard that is used…
-
Multi select checkbox count checked items
I have a multi-select checkbox that I am trying to count checked items in the cell and total in another cell In the column invest strategy capability I want to count items checked in the cell with the first arrow and put the total in the check mark under invest total. Same for the second arrow. I have seen the Countif and…
-
Smartsheet Calendar Populates on Outlook Calendar
Hi, If we use the Outlook Smartsheet app, will calendar items on Smartsheet be pushed to the users Outlook? Thank you, Jared
-
Custom Report Format Possible?
I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For instance if I have the columns and 3 rows. * Publish Date * Category * Title * Body Text…
