-
Hi, I'm looking for formula help with the at risk flag.
Goal: If target finish date is within 7 days OR past due, and % complete is less than 100%, then activate flag. when % complete equals 100%, flag can deactivate.
=IF(AND([Target Fini…
Formulas and Functions13
Cindy Doucet
-
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but …
Formulas and Functions62
scott.barrett
-
Hi,
I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns for links to other places.
I would like…
Using Smartsheet18
Jackie Callahan
-
Now that smartsheet permits emails to outside users my ability to use the sheets has greatly increased! Unfortunately I am running into an issue when trying to send emails to company generated distribution lists. I am not sure if it a secu…
Using Smartsheet135
saltyblueocean
-
We use a standard project plan (~100 tasks/steps) as a template for our team, and it gets copied for each new project. There are ~6 tasks on the project plan that drive Jira task ticket creation. Instead of adding extra columns to the st…
Using Smartsheet25
Garo Stone-DerHagopian
-
Good Afternoon!
I am 2 months new to Smartsheet and enjoying the journey thus far.
Project Background:
I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Maste…
Using Smartsheet21
William Laurento
-
I'm using resource allocation to calculate schedule duration but the schedule isn't updating to reflect the allocation.
Why didn't resource allocation (other than 100%) change task duration?
Using Smartsheet48
Ami Veltrie
-
Would it be possible to use some of the CSS to control the color of the (currently hard-coded as the elements are rendered) cells and other backgrounds using the settings for "Personal Colors and Logos.." and the workspace colors…
Using Smartsheet31
Ezra
-
Hi,
Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.
Lauren
Using Smartsheet67
Improve Consulting
-
I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
Using Smartsheet29
Alejandra Orihuela
-
Hello All, I am new in this community and i don't know this is right place to ask this question. I am working as a manual tester, I am confused for the difference in agile and waterfall model as a team coordination point. Can anyone know a…
The New Work/Life Reality42
Ankit Dixit
-
One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transfo…
Using Smartsheet347
E_Pieper
-
Hi,
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Basicall…
Formulas and Functions950
LouiseM
-
Hi! I have not found this topic discussed yet. We'd like to do a couple of things with our intake forms.
1. Make the intake fields conditional. Some surveys are set up so that what you chose in field A. will affect what you see for the fi…
Using Smartsheet142
Tom.Richards
-
Hello!
I have a form that allows users to select up to 5 types of shirts. I want to be able to limit the amount. So if for the green shit they select 3 shirts, for the red shirts I want them to only be able to select up to 2, and that wou…
Formulas and Functions49
Hammermill21
-
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows:
We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions66
Melissa P-B
-
Hello, could you help me find a formula that counts all except "x".
I have a Column that has data such as: dates, "ok" and "N/A". I try using the Countif formula but cant seem to figure how to have it count a…
Formulas and Functions262
ELENA LUCERO
-
We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the pri…
Using Smartsheet120
OrbitalPorcupus
-
I'm hoping the smartsheet Gods can help me.
I'm struggling. I have 126 projects in my sheet and about 30 different project leaders. Each project leader is set up as a contact (see 2nd screentshot - Pink)
I'm trying to count projects by…
Using Smartsheet203
Melissa Shoumlisky
-
Hi there,
I have my sheet set to show rows in descending order of dates, from most recent to oldest. However, when I use the card view, it shows the cards in the reverse order -- from oldest to most recent.
Is there a way I can sort my c…
Using Smartsheet91
jmhoward
-
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Curre…
Premium Apps and Integrations189
tcanelli41471
-
In the available columns to display in a report, there is no option to show the row number of the record from the source sheet. Is there any alternative way to accomplish this? If not, can Smartsheet team please add this to the feature enh…
Using Smartsheet225
SK
-
Hello team
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advance
oded
Formulas and Functions719
odedL
-
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
Formulas and Functions290
EmilyH
-
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLAN…
Formulas and Functions68
Shirley Vue
-
I was wondering if this is possible yet, or if there have been any updates?
https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet
Importing from Smartsheet into Outlook is nice, but I would love to have…
Using Smartsheet320
Paul Newcome
-
Hi!
So--I have basic formula knowledge but feels like I'm outside my wheelhouse.
All I want to do is return a specific start date based on a couple criteria:
Week (1-7, beginning 2/20/20)
Start time (morning, midday, night) Note: all m…
Using Smartsheet65
kolfinna
-
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
(Image)
Formulas and Functions24
Quran Fulton
-
I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…
Using Smartsheet72
poweb048
-
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it.
Thanks!
Using Smartsheet334
Sgiovinazzo
