-
Using IF formula to reference any change in cell (adding a value)
Hello Experts! I was wondering if a formula like this is possible: =IF([Confirmation #]@row = "any value", "Confirmed") When a confirmation number is added to a cell, that means the item is confirmed. What can I put in place of "any value'? I am just not sure how to do this in the context of my larger status formula:…
-
Automatic creation of sheets
Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker that I've setup as a template. And can those trackers be automatically saved in another…
-
Trackers feeding other trackers?
Hello, What is the best way to "push" rows of data from multiple trackers into one tracker? Suppose user 1 and user 2 and a Manager use their own trackers. The trackers follow the same template. User 1 and user 2 must report progress from their trackers into their Manager's tracker. They must report entire rows from their…
-
Document Builder
We have a fillable pdf that we use for daily reporting, tied to a sheet via document builder mapping, and are testing it's use for our purposes. Once we're satisfied with how we have it built, is it possible to keep that fillable pdf attached to our daily report "template" sheet when we save it as new into project specific…
-
Dashboard widget borders
Hi. I'm full of questions today. I see in some of the examples on smartsheet website, the widgets have borders. How is this achieved? I'd love to do that for my dashboard. THanks, SB
-
Document Builder & Templates
Hi Everyone. I have learnt alot from the smartsheet community and really appreciate the hard work everyone puts in providing answers. I am having a problem where I map all the fields to a pdf in document builder and it works fine but when I copy the sheet set (it is a template set for construction projects) the mapped PDF…
-
Timeline for projects
We have several projects with us, and would like to display them all together clearly in a timeline. Unfortunately I can not find a template or anything else for this, can someone help me? for example sth like this: Thanks! Best Dominic
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
-
Automatic project creation and reporting
Dear community, I have a scenario which gives me quite a headache. I would like to create a form which will be populated by the project requesters for creating projects in Smartsheet based on a set template. The form will have multiple fields. Once the form is submitted it will have to trigger an alert/reminder for…
-
Cell Link inside of a Template
Does anyone know if, or how, we can put a cell link inside of a template?... I'm looking to have all new sheets created with a template automatically have a link back to another sheet. Example... I have a template to start new projects with and I'd like to have another sheet that lists all the projects. So as new projects…
