Using Smartsheet
Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.
Discussion List
-
how to automatically lock a lineIn Using SmartsheetHi all, As you can see on the print below line 559 goes from "empty" to "Bruna Regina" and about 30 minutes later, same line goes from "Bruna" to "Fabio" at the first action my employee Jessica u…
-
Auto-generation duration using start AND end-date predecessorsIn Using SmartsheetHello everyone! Is there any way to define start AND end-date predecessors (e.g. 2FS, 3SS) and thereby have the duration calculation auto-generated? Yes, i did put the exact example above into my predecessors column, but it doesn't work.…
-
Creating unique unitsIn Using SmartsheetHi all! I was hoping if anyone had any idea as to whether we are able to create unique units. In excel, you are able to create custom units. Such that if I entered '1000' in a cell, it would automatically be displayed as 1000 mL. I know t…
-
Redirect smartsheet links to the published link.In Using SmartsheetHi there, Hopefully you guys can help me with this, as it would be something that would really help me out with the way my company uses smartsheet. I have a template workspace I've put together that contains portals / dashboards wi…
-
"Persistent", one-time date functionIn Using SmartsheetI'd like to see a function like "TODAY()", or cell behavior that supports it, that executes only once when an event is triggered so that the date result that never changes. My use case is a Card view Kanban board with status st…
-
Smartsheets sends alerts for templatesIn Using SmartsheetI have an issue where we have created a bunch of templates that include notifications. Those templates, even though they are not active sheets are sending reminders to the individuals denoted in the column specified in the template even th…
-
CountIf from another sheetIn Using SmartsheetHi All, I am trying to do a COUNTIF and refrence another sheet but I keep on getting an error. =COUNTIF({Go New Products Range 1},Category:Category,"Footcare")
-
Function HelpIn Using SmartsheetHow would I go about trying to create a formula that scan down a column finding and grouping the same "assigned to" and then grabing that specific %cost and totaling them up in another cell?
-
auto-numbering Created (Date) grayed outIn Using SmartsheetI am trying to have my sheet keep track of new entries created using my form. I found that I could use Auto-Numbering and select Created (Date), by looking through the forums here. However, when I try to change the properties of my form, t…
-
Looking for General HelpIn Using SmartsheetI am relatively new to SmartSheet. I have been using it as a glorified spreadsheet for about a year in my small business. I opted for it due to the notification feature as I work remotely most of the time. As I always seem to do, if I fi…