-
How can I total numbers across two sheets?
Hi everyone, I need some guidance on setting up a formula. I've got two separate sheets with consistent fields including name and position/title. I want to total numbers from one sheet using the name and position fields as parameters. In the past, I've used an average formula (pasted below) with success. I'm looking to…
-
Capturing Contact with email in Forms
I love the fact that a Contact field can contain both the display name and email address in one. For our current project, we don't have a way to collect all of the contact names & email addresses ahead of time, so we are capturing that first entry in a Form (along with other key pieces of information). For a user to…
-
Remove T and Z from DateTime, and reformat date/time column
I used bridge to populate a "time Completed" column at the time a status changes to Resolved, by placing the time modified into this clolumn. However, that's giving me a datetime formatted like: "2024-12-10T19:02:08Z" I'm trying to reformat this datetime to align with the default created datetime: "12/09/24 11:34 AM". Can…
-
I am getting an error while Provisioning a Project via Control center with Resoure Management
Hi I have used a working Control center blueprint to set up another one that is integrated by resource management using the steps here https://help.smartsheet.com/articles/2482511-use-resource-management-with-control-center. I am using a reseller demo account for this The new Control Center blueprint was successfully…
-
Dynamic View date column filter now generally available!
Hi Community, Dynamic View date column filter is now available to help you navigate to the right subset of data and quickly sort the way you want! Spend less time sorting through large sets of data and easily find the information you really care about. Filter data with new date specific conditions such as 'is a date,' 'is…
-
Allow copy of a direct link to a specific attachment in a row
I would like to suggest an enhancement to copy and send a direct link to a specific file Attachment to a row, when there are multiple files attached to the same row.
-
Increase sheet row and column limits
Hi Guys, What is the possibility to increase the row (20 000) and column capacity? I'm working for a company that headcount surpasses the 20 000 mark which makes it extremely difficult to utilize smartsheets, which we really want to do. This would truly make a huge difference in building a database etc.
-
Absolute references in an Index Match formula
We have a sheet called Intake Sheet that has a line for each project. Each project has a Project Metadata sheet that pulls information from the Intake sheet by using an Index Match formula with cross sheet references. This was set up for us by a Smartsheet developer and it did work but I moved some columns around in one of…
-
Report column groupings showing text under the grouping name
I am attempting to create a report that groups ticket IDs by the report name. The grouping is based on the column named "Report Name Internal (Final)" and the undesired text being displayed is from the primary column. The grouping name displays text from the primary column below the report name. What's odd is the undesired…
-
Index/Match Function returning Unparseable
Hi Team, I am attempting to pull in dates from a Project schedule into a Program plan across 2 smartsheets. I have used several variations of Index Match with no success. My key indicator is a unique number in both sheets. Exp: I would like have the formula return the funding approved date from the project schedule into…
