-
Filter option after Building a Report
Hi, After building a report, it would be great if we had the ability to use filters similar to the other sheets. Thanks, Brent
-
Formulas with Conditions
Hello, My goal is to have a formula populate the dues dates with one condition. Currently Drawing Due Date is populated 2 weeks from Order Date If the "Type" Column is "Q" then I need the Drawing Due Date to be 1 week from Order Date. Current Formula: =$[Order Date]289 + 14 Thank you for helping me with this in advance.
-
Estimate End Date, Actual End Date, Adjusted End Date flagging
For my projects I track Estimated/Actual Start and Estimate/Adjusted/Actual End dates. I need to have a status flag indicate yellow if the Adjusted date is slipping past the estimated end date, and then when the end date is adjusted and justified, to update the status flag back to green. Is anyone tracking like I am? Do…
-
Select a cloud service folder for attachments
I would love to use something similar to the existing Box, One drive, etc, integration to be able to select a whole folder to attach rather than just individual files. When a new file was added to the folder in Box, it would also be available in smart sheet.
-
Google Calendar/Publishing To Incorrect Email
I was wondering if anyone else has ran into this issue... I changed my email address associated with SS and unable to get the Calendar to publish to the newer email address. My old email is deleted out of SS, but still only publishes to that email. I have turned it off,deleted calendar and turn publish back on, but had no…
-
Formulas
I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
-
Adding people to a project
I am brand new to this and am exploring smartsheet. We have a team of ten. We have about 12 projects. Each project is managed by various individuals among the ten of us. Some projects have two people, some have six. The first thing I am doing is creating a new project for each of our projects. How do I assign people to the…
-
Traffic lights count by colour if children
Hi there, I'm trying to count the number of projects according to their traffic light status across about 7 sheets. Given I want to display this in Sights as a Metric, I can't use a report so I have a sheet linking to the summary information from each sheet. When I use the Countif formula to count those that are "Red" it…
-
Send Update Request - Button not Hyperlinked in JIRA ticket
Hi All, I use Send update request to email alias that automatically creates a JIRA ticket. However the Open Update Form Button - is not linked in the JIRA ticket description ? Any ideas how I can get the Update Form button to open ?
-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…