-
Set an End Date for Project and use predeceasors to work backwards
I have Parent and Child rows set up in my sheet - Parent is the project and Child rows are the steps. I want to set the expected "Completion date" in the final child row and automatically (with set durations) work backwards to determine the expected "Start and Completion date" for the child rows that need to happen prior.…
-
Count the # of times a person was assigned a specific request type task and in what month
Hello! I need help applying a formula to reflect the following. Background: We have two sheets: Observe Request - Completed Client Insights Client Insights Tracker What we need: Apply formula in the client insights tracker that pulls from the observe request - completed client insights file that shows the count (#) of…
-
URL Query report options
Create query endpoints for reports so a link can auto filter a sheet when the URL is clicked to do certain things. This would make it much easier to manage reports for weekly/monthly/quarterly, and many other things. In my use case, this would simplify how many separate reports are needed. Below is an example of what could…
-
Automation workflows that were working are no longer emailing gmail and msn addresses
Our existing workflows that trigger automated email alerts have started failing. It started in the last day and only affects gmail and msn addresses from a contact column. The failure message is, "Due to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow".…
-
Quick Tips and a list of Frequently Asked Questions
Quick Tips for engaging in the Community 🔎 Search before you post: Before you create a new post, search to see if your question is already out there. 💬 Be descriptive: Include screen shots and as many details as you can when asking questions or providing an answer (without exposing sensitive data). The more details you…
-
Outlook Calendar integration showing time of event and not just the day,
Smartsheet is great for planning events but when that date is added to an Outlook calendar, it shows up as a day event and not the specific time of the event. Not only does it look like a day event but the inability to change the calendar to the appropriate time of the event is creating more work. It would be great if this…
-
Jira Connector Error - Illegal Character
Hello, We are working on a bi-directional sync via Jira Connector and continue to receive this error when we try to push new tickets into Jira from our Smartsheet (which is successfully receiving Jira updates and updating existing tickets) - JIRA rest client exception occurred while syncing issue.…
-
Odd behavior with Index(Match
Using a basic Index(Match on 1 criteria to cross reference 2 sheets. I've checked multiple times that 1) the cells pulling in are actual numbers (no formulas), and 2) there is a MATCH to pull in. Here is the formula - appreciate help on what I'm missing =INDEX({Equipment Leadtime - MPTs MVA Limit}, MATCH([MPT…
-
Publish Report without Attachments
I have a sheet that I used to create a Report with only certain columns and rows displaying that I want to publish/embed into SharePoint to allow people to view the information in a read-only view and see the latest data. I do not want them to have the ability to access the attachments for these rows. It doesn't look like…
-
Hide Attachments and Comments on Reports within WorksApps
We have some internal sensitive data saved as attachments that we do not want our clients to see. I have hidden the Attachments and Comments Column on the Reports and saved them as View Only within WorkApps. However, the users can still view the attachment even though I have hidden the Attachment column, by right clicking…
