Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Find / Mid / Len / Right Formula Question
Good Afternoon All, I feel like I am close but just might need a little assitance to finish this formula. However I am trying to pull the "Month_Year" from these text strings I keep getting "Incorrect Argument erros when I try to put this in. I think it is because some of these text strings are longer than others or other…
Automation for ever-changing database
The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I want to create visuals on a dashboard for various statistics based off the columns of information. I used =countif and it worked well for some columns, but I quickly ran into an…
Did anyone else have a huge number of outdated automations go out this morning?
Hi, I have a large number of users reporting that a significant amount of automations dating back to 2022. It seems to be across multiple workspaces that are not tied to our control centre. Has anyone else experienced this?
Field Value Duplicity Validation Prior to New Form Submission
Hello, I have a form where the user needs to inform the number of the invoice and attach the PDF file of the invoice. It is very comum for the user to attach invoices that have already been attached in the past. Is there any way I can configure a validation that prior to new submission in the form, it checks if there is…
Chart Error Message Instead of 'No Data' When Overdue Items Report is Empty
This discussion was created from comments split from: Unable to display chart - Unable to read the source data.
How can I get my subtask to be counted in the same format as my work breakdown structure?
The subtask in my work breakdown structure is being counted as 1.1 (first screenshot) and I want this to be the same for subtask on my intake form (second screenshot). Is there a way I can get my subtask counted in the same format? I currently don't want the subtask to be counted as 6.107, I want it to be counted as 1 and…
Dashboards and Reports
I'm building a Project Office (PMO) with 80 projects and looking to build a project dashboard for all 80 projects. We would need 4 reports per project (project summary info, project plan, issue/risk log, and project contact list). I'd rather not develop 320 reports (80 projects x 4 reports). Is there a way to do this more…
Remove Holidays
I am trying to get the number of days a case has been opened that excludes days I have entered as holidays. For instance. I have date assigned, disposition date and the type of review level the case is. I created a column to capture all case review levels (first formula listed below) and a 2nd formula so I can reak it down…
A sheet can include no more than 100 distinct cross-sheet references.
Is there any chance this can be increased in the future or has been in discussion? @Paul Newcome
How do I prevent a new row from inheriting conditional formatting from previous row?
Hello, is there a way to prevent a new row from inheriting the same conditional formatting as the previous row? I have it set up so the color green highlights the row once info is added to 3 specific cells. However, when I create a new row and start filling it out, the row turns green - even though I've added info to cells…

Popular Tags

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags