-
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 Smartsheet112
Michael Lockwood
-
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 Smartsheet12
rcabral
-
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 & Developers18
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 Smartsheet47
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 Smartsheet361
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 Functions803
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 Functions54
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 Smartsheet591
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 Smartsheet64
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 Smartsheet354
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 Smartsheet155
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 Smartsheet64
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 Integrations137
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 Integrations384
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 Smartsheet130
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 Smartsheet49
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 Functions81
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 Smartsheet109
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 Functions212
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 Smartsheet371
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 Smartsheet89
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 Smartsheet38
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 & Developers288
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 Functions71
Amy Arnold
-
Hi!
I am working on creating a report in which data is obtained using a Smartsheet form.
https://us.v-cdn.net/6031209/uploads/781/KSSZYBE6N9EB.png
https://us.v-cdn.net/6031209/uploads/547/MXTN397LY9XS.png
For each new answer on the form…
Using Smartsheet35
Jefferson Ribeiro
-
Hello,
I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message.
=SUMIFS({MH Client Profiles v2 Range 13}, &quo…
Formulas and Functions1165
Amanda Chu
-
Hi,
I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION.
Here's my Master Smartsheet.
https://us.v-cdn.net/6031209/uploads/745/RJB22XU6CD5F.png
This is the formula I started using based on responses in the c…
Formulas and Functions24
Amy Arnold
-
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget).
I collect weekly "submission date" data from 40+ people. I have created a report that shows when the sub…
Using Smartsheet485
Pam Tadsen
-
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 Smartsheet195
SK
