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.

Apply a rule to multiple sheets
I have 75+ sheets that represent properties where my company does cabinet installation work. I am wanting to create rules and apply them to all the sheets at one time. As of right now, I have to re-create the rule 75 x's. Is there a way to create the rule once and apply it to all my sheets? Thanks for your help.
Linking Sharepoint to Smartsheet
Is there a way to link a cell from Sharepoint into a Smartsheet form? Currently my dept. keeps a lot of numbers in Sharepoint. When they update certain numbers, it would be easiest if it could automatically be linked into Smartsheet as well. Looking for a way to do this without having to recreate all documents into…
Feature request - unlink Task Bar colour from applying conditional formatting to whole row
Hi, I see from the page here https://help.smartsheet.com/articles/516359-conditional-formatting that 'For rows that meet the condition, apply a color to the card border in Card View or the Gantt and Calendar bars in Gantt View or Calendar View. A color will be applied to a card, Gantt bar, or calendar bar only if you've…
Trigger reminder on absence of comments
Hi, It looks like the "modified" column doesn't update when a comment is added to a row. Comparing this date/time value to today's date/time value is the only way I see to automate a reminder when a row has not been updated (and by updated, I mean a comment left on the row, not a cell changing). example - remind 'assignee'…
Do dashboards and reports count as 'sheets'?
Hello All, Due to the limit of 100 sheets per user on the business plan we often try to spread the sheet ownership between the licenced users. What I haven't fully figured out yet is whether dashboards and reports take up 'sheets' or whether your total owned sheet count only refers to actual sheets?
Automation not following Conditions set
I'm not sure what I am doing wrong with my automation. I have an Update Request and an Alert automation set up as one Workflow to send out if an upcoming task is less than 70% complete and is not a Parent Row. The problem is I continue to get notifications for rows that are 100% complete and rows that are Parents. What am…
Resending a Row with attachments
I have an automation set up to send an "update"/"notify" a specific person when a new row is added. I didn't select any advanced options. We didn't want him notified EVERY time a small change is made to a row, but there are times he has updated significant information and he essentially wants to resend that row to himself.…
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?
As part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has completed their modules and who has not. Do I as the Sys Admin have access to view all…
Resource Management
If I have a taks that is going to take 300 hours to do and I have two resources available to each work 40 hours a week, and I enter a start datem how do I get smartsheet to automatically update the end date based on the 300 hours estimated and the hours they are available to work? Thank you
After join two smartsheets files into one the formatting disappears.
I am using a join to get information from other smartsheet files; I activated the percentage icon and nothing happens and the other fields with regular numbers also lost the original format; if there is no directly solution, I was thinking if I can apply the TEXT formula from Excel, but I couldn't find the equivalent for…

Popular Tags

Trending in Smartsheet Basics

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags