-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
Formula to return multiple contacts based on multi drop down options
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminders). In the sheet "Seasonal, CDL, & Missing Requirements", I want the "HR Contacts for…
-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
-
Formula-Reference another sheet and see the column rather than(SheetName Range #)within the formula
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Contact Month], "Jan", [Point Person]:[Point Person], "Mark") I have another sheet named "Summary - 2020". I want this exact…
-
Docs sheets in Smartsheet
Hi Are there any plans to introduce documents alongside sheets in Smartsheet? (like Google Docs and Google Sheets in Google, and Word and Excel in Microsoft) Thanks Cheers Richard
-
Formulas not showing in new rows
Hi, Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it. The first attachment shows how the sheet is setup and a number of columns have formulas in them. If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down…
-
Having problems embedding Smartsheet into new Google Sites
Hello, I am not able to add my DevOps course list attendees embed with a Smartsheet into the new Google Sites. I can easily embed other sites like soundcloud (works rather well). Please help - thanks.
-
Losing data when multiple users making changes at the same time
Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/reports respectively, I keep losing the data in my cells. How do I ensure to get their…
-
Compare the hours allocated to the hours actually worked, through timesheets
Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the…
-
Auto Assign Contact based on number of Open Tasks
Any help would be great. I have a form that dumps information into my sheet and would like to auto assign the task to a person/contact when it comes in. The Assignment is on a rolling basis. For example I have 4 people and as the work comes in it gets assigned to each one then starts again at the top of the list. Has…