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.

Contact list and look up table
Hi, I am trying to set up automated alert to an area manager that is associated with certain stores. (Several Stores and several managers) This information is driven by forms and the only information that is chosen ( for this part) is the store name. I have managed to create tables and formulas that then auto populate the…
Can Viewers hide or filter columns that don't pertain to them?
My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only). For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.…
Clear cell data based on dropdown selection
HI, I need to clear a date in a cell when a dropdown list selection is set to completed. This will then in turn remove the notifications from appearing and removed the conditional formatting used a visual tool. Ive tested an IF statement on the date cell, by adding the IF statement, adding the date and then selecting the…
Sights separator lines
Hi All! Could someone tell me how to add kind of separator line like this one? It is sight from smartsheet's template. It is fully interactive, so if I want make it wider, it is enough to drag the corner of this field. I tried to add a picture of a line from an icon, but it does not expand its width.
Transfer exet document to smart
Hi, I have to transfer excel doc. to Smart. Never work with Smarrsheet. I do not know how to transfer taps and all formula they have, they also all link to each other.
Multiple references
New to formulas and need some assistance please. I need to calculate the sum of a column if a check box in another column is checked and between a certain time frame and for certain assigned employees All i have been able to do is sum the check boxes within a time frame =COUNTIF({Deal Tracker - Acq Range 1}, AND(@cell >=…
FS date calculation issue
I have the following calculated task dates in a gantt chart: Task no. Duration Early start Early Finish Dependency 22 60d 1-Feb-2021 23-Apr-2021 23 60d 29-Jan-2024 19-Apr-2024 22FS+720d (See attached screenshot) Task #23 is supposed to start 720d after #22 has finished. But if you manually check the number of days between…
Summing up everyday new entry value into a different smart sheet
Hi, Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please. I can sum up specific cell values or range but i am looking for sum of daily entered values of same column from different sheets.
Access of a Report via Dashboard
Background: I have created a form to capture Company personnel’s proposed ideas to improve cost savings, quality and safety. With this I have also created a Dashboard to give a snapshot of the progress of all Idea’s submitted. On the dashboard I created a button that I had intended for a person without a Smartsheet sign on…
How Smartsheet define, handle and monitor allocation on teammember
Hi fellow Smartsheeteers, I encounter another challenging scenario that some of you have encountered and find a solution to it. Here is the scenario: I have task as an individual and also have task as a team member. Example of task that involves team are doc reviews with a group of people. I have numerous scenarios: 1)…

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