-
Is there a way to prevent users from moving on to next cell...
...without entering a value in a particular cell? For instance, I want to make sure that users enter a ZIP CODE is a row - If they do not, I would an error/warning to pop up or, at least, inability to save the entry without entering the ZIP. Any suggestions?
-
Flag based on multiple columns
Hi, I have created a monthly scorecard smartsheet with formulas and conditional formatting to change the color of the cell based on certain criteria. Now I would like to add column with a flag if a KPI is red for 3 consecutive months. Can anyone share how can this be done? Thanks in advance for your help!
-
Importing Comments from Excel
Hi, Is there a way to import comments made in the individual cells from an excel sheet to Smartsheet without having to retype all the comments?
-
Alert when adding a new row
Hi, We have a sheet where we keep track of current statuses of our clients and this act as a mini project management tool for our clients. Each client is in a row and the stages are indented underneath. We would like to create an alert to notify specific persons everytime a new client is added, and this we have done it by…
-
Obtaining information from a Parent
Hello Community. I have two substasks in a task. At subtask level, I would like to assess information from the task. You can consider the enclosed screenshot. Please consider the cell highlighted in light yellow. For this cell, I would like to access the quantity from the first line. INDEX(PARENT(),1) does not seem to…
-
Nested IF
Hi I am looking to do a nested if so if a value is x y is returned, see below details-; * IF COM = A * IF CR = B * IF HAR = C * IF ARF = D * IF AR = E * IF PSRF = F * IF PSR = G * IF 2020 PSR = L I am having an issue with the below formula's (whichever way round I put it): =IF(Type117 = "PSR", "G", IF(Type117, ="PSRF",…
-
Identifying Current working Task and it's Parent
Good day! I've been reviewing quite a number of ways in finding the current task, last completed cell in a column, etc etc and cannot get what I need to work. I've attached screenshot with the data in my sheet and I'll provide the formulas below. What I'm after is looking for the last non-blank cell in the Status column,…
-
Charting cell values over time
Hello, We are using the smartsheet as an interactive issue resolution tool in a workspace environment where each project has its own smartsheet. We have the dashboard set up which pulls key data points we are aggregating within each smartsheet (ie number of open issues, how many are high priority, medium priority low…
-
Hierarchal columns
I am very new to Smartsheet and have tried to search the community in the hopes maybe my question was already covered, but unfortunately, I did not find anything. I am hoping someone could help me. Is it possible to create a smartsheet like the below created in google sheets? The 1's and 2's represent checkboxes on the…
-
linking checkboxes between two sheets vice-versa
I have two sheets full of checkbox’s. Sheet 1 is a summary page Sheet 2 is a working page Sheet 1 gains automatic inbound ticks linked in from cells in Sheet 2 However, my question, is, in the Summary page (Sheet 1), I would like to sometimes tick “off” a cell AND THEN HAVE THE ASSOCIATED Cell in SHEET 2 automatically tick…
