-
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 Smartsheet846
Frank Falco
-
Hi,
(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.
BUT....
It now red …
Formulas and Functions33
Ruth 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 Functions8
Halil 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.
Using Smartsheet807
KMart
-
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 Functions96
kari1282
-
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…
Using Smartsheet350
Fly.on.the.wall
-
Hi,
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…
Using Smartsheet170
eskaplan
-
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 Functions13
Paul Dieterich
-
Hi All,
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 & Developers159
shekhar.kanade109651
-
Hello,
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 Functions14
John Sisounthone
-
(Image) Hi,
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, …
Using Smartsheet22
itsnotbroken
-
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…
Using Smartsheet228
Lboud
-
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 Functions12
Denise Heffron
-
Hi,
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…
Using Smartsheet243
irene
-
Hi Community,
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 Smartsheet213
Juston 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 Smartsheet63
Daniel 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 Functions1824
laura.buchanan
-
Hello,
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 Functions32
Michael 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.
=IF(Complete…
Formulas and Functions193
chicago25624
-
Hi
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 Smartsheet473
Andy 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 Functions11
Corey 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 Functions21
Corey 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…
Using Smartsheet1426
Stevefc
-
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 1.1.2.4 etc. But I want a system where…
Using Smartsheet11
Naveen 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…
Using Smartsheet288
Horace
-
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…
Using Smartsheet458
Ivana
-
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…
Using Smartsheet632
latsyrcg3
-
All,
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 Smartsheet834
Jess 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 Smartsheet21
Gil 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.
Recurring
On hold
Pending approval
+ In Progress with a Go-Live date of a…
Formulas and Functions11
Krista Horvath
