-
CONDITIONAL FORMATTING FOR DATE TYPE CELL
Greetings I need to apply conditional formatting to a date type cell. I need to write a formula such that, when a the target number for a certain task has been reached, the deadlines for the next target has to be set. For Example, if the target for task A has reached today, then the start date for the next task should be…
-
Jira Connector with Story Points
We have been successful, through trial and error, getting Jira connected to Smartsheets in a bi-directional fashion. One key piece of functionality that would be helpful is utilizing the story points from our Jira system. I noticed in the workflow builder we don't see that as an option to migrate our Jira Story points into…
-
Project Completed If Date Entered
Hi, I am trying to extract a confirmation from a row containing dates. The objective of the following formula is to determine if a date has been entered and if so, display the number 1. If not, to Display a zero. Note, the formula works when information is not entered in to a DATE column, however when the cell is blank, it…
-
Stacked Chart
Hi All! I am trying to move a document from excel into SmartSheet and I was wondering if anyone knew if I could recreate this data into a dashboard chart? It is not currently set up as a chart in excel, it is a tedious exercise of lengthening and creating new shapes to designate the progress. I have tried a couple…
-
Lock Columns
Each member of my team have their own report, they all have the same columns as part of their report however, each person is in charge to update the information of only certain columns. For example, if I have 4 columns name A, B, C and D and 4 reports each of them for 4 different people that are able to see the 4 columns.…
-
Owner to Admin
Can anyone tell me how to change myself from the owner of a report to the Admin?
-
Dynamic View - new submissions
I am an administrator in Dynamic View and have created a new view. I want my staff to be allowed to submit new items. I have selected that as an option but cannot figure out how to have them actually add a new line. Help!
-
Summarizing from multiple sheets (count, drilling down, etc.)
I've been searching the Community section but am having a hard time finding the exact answer I'm looking for, so I hope someone can help. I haven't worked with Reports or Dashboards before, so I'm just not sure exactly how to set up my sheets for this new project. My company is conducting reviews of our office locations a…
-
Reports & New Columns
Hello - it is possible to add new columns to a report? Ie - add new blank columns? Looking at a strategy for planing where reports issue up to date information, and each team adds on their own relevant columns of information, driven from a Master planning document. Any experience with this, or do reports only generate info…
-
Dashboard - Source Reports
I'm new to Smartsheet. I'm trying to source a report to my Dashboard but it is only allowing me to select reports where I'm the Admin, but I'm the Owner. How can I go about adding reports that I'm the Owner of?
