-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
Workflow Approval
Being new to smartsheet but an experienced systems developer I had set up a multi person approval for capital requests in smart sheet. It was quite ugly and ungainly and smartsheet was lacking features I have used in other systems. So I was very please to see the workflow approval functionality released which goes someway…
-
Calculating Totals
Dear all I deal with importing goods from all over the world, and payment usually happens in multiple currencies. In smartsheet, I have a column for currency (USD/Euro etc) and the next column I have the amount. What I am looking for is a payable total in each currency, E.G. For Payable euro, the formula will look at all…
-
Countif Query
Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) This works fine, although there is a scenario where we often add things to the job, which is identified by a letter A in the…
-
Latest Discussion comment viewed in a cell
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what the latest comment is without switching views.
-
How much does it cost to get the Smartsheet-Jira integration piece?
My company is looking into the Smartsheet-Jira integration tool. I have been tasked with finding out a pricing structure. I have gone to the website and requested help on four different occasions. However, nobody from Smartsheets has responded to my request. Does anyone know the price structure for this…
-
Changing cell to "0" if checkbox is checked
Wondering if it is possible to change a cell to "0" if the checkbox is checked. I'm assuming a formula will need to be used since I was unable to find it in the conditional formatting. Thank you for your help in advance.
-
Querying a column from another spreadsheet
I have two tasks sheets. I use one to monitor "projects". I use another to monitor "tasks". I would like to add a column called "Associated Project" to the tasks sheet. I know I can go in individually to each cell and have it link to a cell in the projects sheet. I also know I can set up a dropdown list with a projects.…
-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian
