I would like to know how to create these colored panels as shown in the Sales Pipeline and Forecast dashboard example on https://www.smartsheet.com/all-about-sales-pipeline-management. I have tried using rich text and title text and metric…
Using Smartsheet846Frank Falco
(Image) I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great.
It now red …
Formulas and Functions33Ruth Potts
I currently have a sheet with Smartsheet Licensed Users in our company, we want to check the last time each user logged in to Smartsheet so that if we think they do not require a license we can remove it from their account.
I currently do …
Formulas and Functions8Halil Olsen
Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.
Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet.
Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeep…
Formulas and Functions96kari1282
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but…
I have a sheet with about 500 rows, with a lot of hierarchy (indents) within it.
My ultimate goal is to be able to sort rows by one of my columns, and not have the indents alter how the rows are arranged after this sorting. Therefore…
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status".
Each parent row is a different year and beneath each year are cases ID…
Formulas and Functions13Paul Dieterich
Raised two cases with Support but no response so starting new discussion.
We have created smartsheet webhook with callback url having port 443, 8008,8000 and 8080 but able to get response when callback url configured with 443…
API & Developers159shekhar.kanade109651
All of my Parent rows are expanding automatically when I have a filter on. This happens every time a member of my team refreshes the page.
Is there a way to have my filter on and keep the Parents rows from expanding automatically?
Formulas and Functions14John Sisounthone
Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, …
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the dat…
I'm looking to create an automated workflow to copy any row from a project plan that has the end date changed by 5 or more days. Is there a formula I can include in the automated workflow to accomplish this?
Formulas and Functions12Denise Heffron
Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing sam…
I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet.
I'd still like to use t…
Using Smartsheet213Juston Oakes
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…
Using Smartsheet63Daniel William Maycock
Can anyone tell me what might be wrong with this formula?
I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2…
Formulas and Functions1824laura.buchanan
I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on…
Formulas and Functions32Michael Voth
I am attempting to do the following.
If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100%
Here is the formula I thought would work using task 4.of the project.
Formulas and Functions193chicago25624
I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below…
Using Smartsheet473Andy Skinner
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-mont…
Formulas and Functions11Corey Fletcher
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank.
Project Status = Active
Schedule Complete Date…
Formulas and Functions21Corey Fletcher
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 18.104.22.168 etc. But I want a system where…
Using Smartsheet11Naveen Srikakulam
Is there a way for admins on workspaces to be able to rename them, or is it only workspace or sheet owners that can do this? Since the admin has full sharing/editing rights, it would be helpful to have them be able to do everything the own…
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - w…
Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
Using Smartsheet834Jess Evers
Client submits file through form.
I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on peopl…
Using Smartsheet21Gil Nash
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria.
+ In Progress with a Go-Live date of a…
Formulas and Functions11Krista Horvath