-
How to get individual cells to show remainders.
I'm currently working on making two separate sheets. One is where providers can submit that they have extra of something (someone submits that they have 5 extra bags of concrete, another person submits that they have 7 sheets of metal, etc.) with their email attached (so multiple of the same kind of material cant be…
-
Creating a Booking Tracker for Talent Acquisition in Smartsheets
Hello! I am looking to create a booking tracker in smartsheets to support with its automation. I wanted to see what is the maximum of tabs that can be added to a sheet? Can smartsheets have similar abilities as Tableau, where we can upload a document and pull data from it? I.E. pull from data source continously, automate.…
-
Formatting all Indented rows
Hi, Is there a way that I can change the colour of all cells in Indented rows rather than going thought them all one-by-one? Cheers
-
DocuSign and Contact List Field
I utilized a contact list field in a sheet that is mapped to DocuSign. Although in the sheet it displays the first name and last name, when it maps to DocuSign, the email address shows up. How can make the First Name and last name only show on a field mapped to DocuSign from a contact list field?
-
Countifs Formula
Hi Smartsheet Team, I have captured this student id no. 2307647 Programming session hours is 1.5 hours. (see below) Then, I worked on the metrics sheet to show the hours on the programming session - Complete. It shows only 1 hour, even though I added the decimal spaces. the formula for Programming sessions - Complete is…
-
How to sum data for the last twelve months on a sheet that is updated frequently.
I have a sheet that collects monthly sales and I want to be able to sum the previous 12 months for a specific set of markets. For example, if I wanted to sum the last 12 months for Aiken and Bamberg how would I write a formula that would update as changes are made to the sheet. Each month new data is entered and I want a…
-
Access given, but no content is visible - why?
Hi. I have created sheets and reports of the sheets. The sheet acts as a master and is managed by myself. My team will mainly work in the respective reports. The problem I am facing: I have shared the documents (and later the workspace) with my team. One of my team members can access the report, but when he opens it he…
-
How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an…
-
Smartsheet bug? Time / Rounding formula error
Hi, I'm using the following formula to calculate the difference between 2 times: =IFERROR((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) - (VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) + VALUE(RIGHT([Start Time]@row, 2)) / 60), " ") And then using the…
-
Numbers get added decimals after being linked?
Hi all I have a bit of an annoying issue with Smartsheet adding decimals to numbers after they're being linked - and these dosen't even match my current settings. Currently in our Intake sheet, we have a store number and postal code, which has no decimals. However, when these are being linked out to the sheets and beyond,…