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.

Conditional formatting for a duplicated #
I want to turn a cell red when the # in that cell is a duplicated #. IOW when the # entered has already been entered in a previous cell in that column, I want to turn that cell red. Does anybody know how I could write a conditional formatting rule that would work to accomplish this. thanks, SGF
Way to see all tasks assigned to you/others over multiple sheets?
Hi, i am looking to make it so that I or others in the office are able to see all of the tasks assigned/items relevant to them in one place as opposed to having to click on every single sheet. My best understanding is that this is done through reports. However, lets say in one sheet the column is "assigned to" and in…
2-Way Cell-Linking
I frequently link cells because it is very convenient. Could it be possible to enhance this, so that one doesn't have to use "Go To Sheet" in order to update the value? In other words, can we have 2-way linkage, so that if it's updated in either place, then the value has been updated? I constantly have to go to source…
Group not totaling correctly
I have groups and sub-groups (I hope I'm using the right terminology, I have 8-rows indented under another row) and only the first four rows are totaling. The calculation is for Duration and I am using days and hours.
Calendars
Hi, I'm currently importing a Gantt project backup from another application to view in Smartsheet's calendar view. I wonder is thetre any way to merge several backups in one calendar view?
I AM TRYING TO CREATE A BASELINE, HOWEVER, I AM GETTING AN ERROR MESSAGE
I AM TRYING TO CREATE A BASELINE, HOWEVER, I AM GETTING AN ERROR MESSAGE
PLEASE HELP!
Hi, My name is Christapher and i use smart sheets to run my company and keep up with all of my data and a few minutes ago i created a filter to try and print out a report on one of my drivers. I also deleted a couple of columns at the same time so the driver could not see them. Well when i went back to see my sheet as…
Unable to access Reports
Our team is unable to access reports. They won't load and end with an error. Is anyone else having this issue at the moment? I have been adding conditional formatting to some sheets today. Is that known to cause errors with reporting?
If then statements with date fields
Hello. I am trying to calculate a date field based on the following manually entered data: * If "Project status" is not "Cancelled" [drop down field] * And "Const duration" is not null [text/number field] * Then add "Const duration" to "Start date" to equal "Completion date" * For example: * Start date is 6/21/18 &…
Editing an email sent from a row
I was wondering if there is a way to have someone edit a field when you just send a row to someone. What I mean by this is would be the person receiving the email able to check completed or update a date from just the email rather than sending someone an update request?

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