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 Functions22Titilope 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…
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 Functions34JReisman27
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 Functions20Dustin Shuman
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…
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 Smartsheet131Michael 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 & Developers39Senthil Anandarangan
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…
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…
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 Functions949LouiseM
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.
If I change the status of "Software" to Red (R) in the child row, it…
Formulas and Functions62Cuatro
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 Smartsheet704Jess 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…
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;
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…
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…
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 Integrations158Jacque214
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 Integrations513Tana 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 Smartsheet168Colin 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…
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 Smartsheet26Vanessa 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 Functions99JWattz
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 Smartsheet136Mariana 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 Functions238Athena 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…
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…
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…
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?
API & Developers361katherinehall
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 Functions94Amy Arnold
I am working on creating a report in which data is obtained using a Smartsheet form.
For each new answer on the form, a new report or Dashboard must be created, which must have the format below.
I wonder if …
Using Smartsheet35Jefferson Ribeiro