-
how to automatically lock a line
Hi 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 used a empty line (that´s correct) 30 minutes later, my second employee Evilyn said the line was empty to her too. (she said…
-
Auto-generation duration using start AND end-date predecessors
Hello 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. The easiest example I could give of why one would want to do this is: let's say you…
-
Redirect smartsheet links to the published link.
Hi 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 with links to other portals / dashboards, that are also within the workspace. The way copying a…
-
"Persistent", one-time date function
I'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 states: Ready, Dev, Test, Deploy, Done, and matching columns for their start dates, e.g. Dev Start.…
-
Smartsheets sends alerts for templates
I 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 though they are not necessarily assigned to any tasks (because it is a template!). Any…
-
CountIf from another sheet
Hi 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 Help
How 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 out
I 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, the Create (Date) option is grayed out. Can someone explain what might be going on?
-
Looking for General Help
I 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 figure out it can do "this", I think it should be able to do "that" but I really don't…
-
Expanding rows
I am seeing rows expanded after I've collapsed and saved. It's the same couple of rows. Anyone else?
