-
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column.
(Image) I only want the column to flag is the status is not complete and the target end date is past due. My current …
Formulas and Functions22
Titilope Akinlose
-
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but…
Using Smartsheet285
Fly.on.the.wall
-
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board.
The requirement: Show me the oldest Bill of Lading number that does not have a status of &…
Formulas and Functions34
JReisman27
-
Is there a way to filter/sort by rows with pending update requests or even mass delete all pending requests?
Pulling together a list of pending requests for follow up as well as deleting all stale pending requests before the next automati…
Formulas and Functions20
Dustin Shuman
-
Hi,
is there a possibility to display 2 logos at the sheet level?
I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to d…
Using Smartsheet24
rcabral
-
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet131
Michael Lockwood
-
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
API & Developers39
Senthil Anandarangan
-
Hi,
Is there a way where in my form that I had created to be able to customize more logic behind the selected answers? For example -- if a user selects (no) for question #2 ---- and on questions # 5 the user selects (Need more informa…
Using Smartsheet63
kwt_v1
-
Hello,
I am currently using SmartSheets for our staffing agencies to submit potential candidates to open requisitions. On our side of smartsheet, we have a drop down with the "status" of the candidate (Pending, submitted to hir…
Using Smartsheet473
Nsul
-
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 Functions949
LouiseM
-
I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change.
For example:
If I change the status of "Software" to Red (R) in the child row, it…
Formulas and Functions62
Cuatro
-
All,
Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
Using Smartsheet704
Jess Evers
-
Thought I would start my own thread regarding this since it seems very quiet around this change.
Am I the only one having no luck in using the suggested shortcut CTRL ] to indent?
I am using Windows 10, Chrome webbrowser and swedish keyb…
Using Smartsheet72
Mattias
-
I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up?
This is what I am putting in;
=IF(A…
Using Smartsheet440
brandi.meyer80376
-
I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
Using Smartsheet214
JWattz
-
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
Using Smartsheet76
Shah_0614
-
Has any one here done an integration with ConnectWise?
We have a small company whose resources all work production support and project tickets. If I had a way to feed tickets from CW in so that I could display all open tasks for one perso…
Premium Apps and Integrations158
Jacque214
-
OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy docum…
Premium Apps and Integrations513
Tana Perkins
-
Any idea when or if we will see Card View on Reports in the near future? If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow. Thanks.
Using Smartsheet168
Colin Entrekin
-
Can be possible if the automation email from smartsheet comes with a Customize sender information instead of the information of owner of the sheet? We created a ticket system and the automation email comes with the owners name and when th…
Using Smartsheet69
lcamacho19911
-
Right now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to ma…
Using Smartsheet26
Vanessa Munoz
-
Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what ne…
Formulas and Functions99
JWattz
-
Hi folks,
This article about a SmartSheet competitor, Airtable, has been making the rounds in my little universe of technology products researchers. https://medium.com/@WeWorkUX/the-atomic-unit-of-research-insight-17d619583ba
As user re…
Using Smartsheet136
Mariana Almeida
-
I've seen so many examples of "Nesting IF" formulas for changing a Harvey Ball to a different color based off of multiple numeric or date scenarios. What I haven't come across is a way to change the ball color based off of verbia…
Formulas and Functions238
Athena Hathaway
-
As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me.
After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
Using Smartsheet460
EdL
-
i am trying to work with smartsheet webhooks. Would like to use the callback authentication feature as explained at http://smartsheet-platform.github.io/api-docs/#authenticating-callbacks-optional.
However, the instructions are not very c…
Using Smartsheet116
amitk-productiv
-
Hi all!
I am fairly new to Smartsheet but have been taking training where I can to get up to speed. I'm stuck on one particular issue and I'm hoping someone can help.
I set up a couple of donut chart widgets to track task status for a co…
Using Smartsheet46
JeffM
-
Hi there,
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
If…
API & Developers361
katherinehall
-
Hi,
I'm working with two Smartsheets.
(1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…
Formulas and Functions94
Amy Arnold
-
Hi!
I am working on creating a report in which data is obtained using a Smartsheet form.
(Image)
(Image)
For each new answer on the form, a new report or Dashboard must be created, which must have the format below.
(Image)
I wonder if …
Using Smartsheet35
Jefferson Ribeiro
