-
If Statement
Hi Team, Can anyone help me how to write this condition In Smartsheet Thanks
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Truck Sales Process Template
Hello, I work for a heavy duty truck sales company and we'd like to implement a system that will allow us to track what trucks we've ordered, what their current status is, what trucks have been purchased by customers and ideally send out documents that customers need to sign and return to us; all through an automated…
-
When downloading a template set, the dashboard doesn't seem to download with it.
I have been trying to download the Project Tracking and Rollup as well as the Project Schedule Management templates, which are both supposed to include pre-made dashboards, but the dashboards do not seem to download or populate. When I move the template set to a workspace, the dashboards still do not show, and when I…
-
Using a master sheet to change multiple sheets
Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. deleting a task, adding a task, adding a column etc.) this change has to be made across…
-
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
