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.
Formulas and Functions13Cindy 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 Functions62scott.barrett
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 Smartsheet18Jackie 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…
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 Smartsheet25Garo Stone-DerHagopian
I am 2 months new to Smartsheet and enjoying the journey thus far.
I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Maste…
Using Smartsheet21William 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 Smartsheet48Ami 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…
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.
Using Smartsheet67Improve 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 Smartsheet29Alejandra 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 Reality42Ankit 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…
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"
Formulas and Functions950LouiseM
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…
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 Functions49Hammermill21
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 Functions66Melissa 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 Functions262ELENA 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…
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 Smartsheet203Melissa Shoumlisky
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…
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 Integrations189tcanelli41471
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…
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advance
Formulas and Functions719odedL
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 Functions290EmilyH
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 Functions68Shirley Vue
I was wondering if this is possible yet, or if there have been any updates?
Importing from Smartsheet into Outlook is nice, but I would love to have…
Using Smartsheet320Paul Newcome
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…
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.
Formulas and Functions24Quran 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…
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.