-
Rows lose custom order when using Jira connector
Hello everyone, I've been using Smartsheet to keep a timeline for my projects in Jira. So far everything has been working great but I noticed an issue when reordering rows. When I do this, after a few hours, the rows will return to their original order. I have contacted support and they tell me that if a bidirectional…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Moved data from one sheet to another sheet - now its not showing up
I just moved data from one sheet to go onto another sheet and now it’s completely gone and not showing up. I refreshed and went back into the sheet the information was suppose to be moved to but it’s nowhere to be found. I am trying not to panic.
-
Date Modified - Copy of column creates different date
Hello, I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of the column using the basic formula: =[Last Modfied]1 My results are not what I would…
-
Overwriting lines
We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time. Anyone else experiencing these issues?
-
Flagging duplicates from 2 separate columns
Greetings - I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same formula with the "COUNTIFS" function is leaving the flagged cell blank (as seen in row 2 of the screenshot attached). Here is…
-
Reassigning tasks in bulk to a New Resource
Hi, I have assigned multiple tasks to Jane, but I a new person is now taking over all of Jane's tasks. So is there a way I can bulk assign all the tasks and the sheets to the new person? Thank you!
-
Count of All Items, where Start Date is less than Today
Hi, I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date. I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria. Any help if very much appreciated. Thank you, Deepthi
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
-
Issue with iPhones taking photos with forms
I've been trying to find a solution to this but I'm coming up empty. Long story short, we use a Smartsheet form through a web browser on a phone to collect information. It's sort of an inventory process. At the bottom of the form there is the option to submit files or photos in which we take photos to document different…
