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.

=Min(Children()) not consistently updating for parent row
I am trying to create a column of "Next Action" which will have a date for each row that is manually updated continuously. I want the value of this column for the parent rows to update according to the next/oldest date (whether the furthest in the past, or the closest in the future) of the respective children rows. I have…
Max child value dependent on max date
I have two columns a returned date and a recorded level. The maximum recorded level is dependent on the maximum date. The value will sit in the parent row. Currently I have =MAX(CHILDREN()) in both columns. Can this be done using Children or Parent references or is an IF statement required. First time on the community so…
Date fields in forms
I have a form for users to submit data. One of those fields is the date that they would like the work to occur. In the form, there used to be a little calendar that the user could click on to select a date. That forced the correct date format for the field. Now our form has changed so that the date field is now a free text…
Conditional Web Form Formatting
I am aware that limiting characters in a form (text) field does not exist. Is it possible to apply a conditional formatting rule to a text field in a form that alerts the submitter that they have reached a specific character count (in the field) prior to submitting the form? For example: When character count is greater…
l
l
Doing by date and not by task
We are a Habitat for Humanity affiliate. We do a group of different tasks on each day we build. Can I have a task for the days such as Day One, Day Two, Day Three and so on and make that the predecessor for the different tasks done on that day. If not how do I do it.
How to show more than one month on calendar view
I am wondering if there is a way to show more than one month on calendar view. I am working creating an HR sheet and I need to be able to see the last 12 months if someone took a vacation. Also is there a way in a column to have more than 1 date so for example if someone took off both June 5th and then July 8 can we put…
Summing children rows without double counting parents
Hello friends- I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received. Specifically in the Summary Table, I have a sumifs formula which grabs specific line items based on the date and which installment of the grant they are using. I believe that the…
Sub-task card lane driven my main card
I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have created a sub-task card for each box on the pallet. When I move the pallet card the sub-task cards remain in the lane. The…
Adding Columns on a shared sheet
Good morning, I am sure this is an easy one, but I cannot find an answer or explain why it is happening! I am unable to add any columns to any sheets that have been shared to me. I can however add columns to my own sheets without any issues. Is there a special way to share a sheet so that the sharee has the same ability to…

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