Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :)
Up until now, I've been able to use the Predece…
We are looking to move away from Excel based 'status reports' that are emailed each week to something that is more readily accessible and easier to manage/track.
At a high level, each week an employee completes a status report on the proj…
Using Smartsheet16Ryan Stanish
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
I would like to have a form where someone selects one op…
Formulas and Functions2379Dajah
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column.
Formulas and Functions11Sebastian Avila
So, until we get 10k feet, I am trying to figure out how much of our team's capacity is spent on projects or operations work.
In the sample below, I'd like to know how much time teams and sub teams spend on Projects, Operations, Enhanceme…
Formulas and Functions22Molly Sudmeier
I'm looking for the smartsheet template that was shown in the Audit, Compliance & Security Solution Guide. The guide links to a site that no longer works - I was hoping to locate the template for the pre-audit checklist on page 5 and …
Using Smartsheet115Mindy Johnson
I would like to know if anyone knows how to set up a basic RAG formula based on completion % and the schedule date. Custom criteria would be as follows:
If % Complete = 100, return Blue
If it's not scheduled to start yet, return…
Formulas and Functions30Dillon Friskney
I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so I'm trying to figure out the best way …
Using Smartsheet28Tim Axell
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 complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
Using Smartsheet336Project User
I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk dr…
Using Smartsheet18Terrence Logan
I have a request to make to Smartsheet Support group, and I am sure a lot of Community users would resonate with me, for this feature!
Adding "mailto: " feature as a feature to dashboard widgets. We know that there are a lo…
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…
The New Work/Life Reality582Hunter Reed
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet131Michael Lockwood
Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.
Using Smartsheet67Improve Consulting
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Formulas and Functions950LouiseM
I searched and I didn't find anything for this so I am hoping I did not just miss this.
We are trying to tie our data into Microstrategy for more visualization options. We are using the Live Data Connector. Has anyone been able to …
Premium Apps and Integrations34Liz Beall
I set up a simple workflow. Once someone writes their initials in a column, it should move the row to another sheet. Except it is not moving the row to the other sheet. But when I look at the activity logs from both sheets, it says that a …
Using Smartsheet172Tom Shannon
I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change.
If I change the status of "Software" to Red (R) in the child row, it…
Formulas and Functions62Cuatro
I currently have a smart-sheet that gathers data from multiple vendors (each vendor has a form). One of the columns is an ID which would be entered through a drop-down. The functionality we are looking for is to have unique drop-dow…
Premium Apps and Integrations50Koushik Ganesh
In Chrome, the scroll bar works when you manually drag it but does not work while using the mouse. The manual dragging is a reasonable workaround but would be nice to be able to use the scroll around on the sheet without the scroll bar.
Using Smartsheet73Melissa Campbell
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 Smartsheet704Jess Evers
Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut.
The keys are working just fine (…
Has any one here done an integration with ConnectWise?
We have a small company whose resources all work production support and project tickets. If I had a way to feed tickets from CW in so that I could display all open tasks for one perso…
Premium Apps and Integrations158Jacque214
Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address?
API & Developers230twa10028
New to Smartsheet, is it possible to link fields on a form based on conditions i.e:
- If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Gr…
Formulas and Functions585[email protected]
I'm currently trying to create a countifs formula to count the number of "issue type"(column) "story" where it meets certain criteria including falling within the next 30 days.
My base formula works here:
Formulas and Functions43Evan Summerville
I have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't make it work).
We are migrating servers …
Formulas and Functions35Michelle Rodriguez
I'm trying to figure out how to have our dashboard update automatically when we work off of weekly periods. In other words, we are adding daily metrics that tally into weekly periods. Those weekly periods are collapsed and saved fo…
How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added?
Formulas and Functions33ddrame103286