-
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 Functions32
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 Smartsheet20
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 Functions656
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 Functions25
Amy Arnold
-
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 & Developers153
katherinehall
-
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 Smartsheet83
Michael Lockwood
-
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 Smartsheet271
Pam Tadsen
-
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 Integrations190
Tana Perkins
-
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 Smartsheet355
Jess Evers
-
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 Smartsheet111
SK
-
Hello,
My story seems to be familiar to others, but no past post seems to have a good solution. I've been searching the community forums here for a request time off tracker template (found a couple none actually worked), ended up creating…
Formulas and Functions58
Tyler12345
-
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 Smartsheet58
amitk-productiv
-
Hello,
I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to…
Using Smartsheet22
thunt06
-
Hello,
Will smartsheet look to implement field rules on the forms?
For example:
Show field: New employee email
When field: employee type: New Employee is selected
It would be very helpful to show or hide fields on the forms.
…
API & Developers19
jaquisha.redd64971
-
Hi!
I'm trying to generate custom PDFs with a specific template from a smartsheet row. The workflow currently uses an automation to send an email when the row is "done". Right now, that email contains the "Row Number" …
API & Developers57
bcromie
-
I have created several contact groups in smartsheet for entire teams that need to work on certain tasks, only to realize that these groups are not automatically included in my contact directory within the sheet itself. Is there a way to as…
Using Smartsheet81
Hannah Womack
-
SS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the l…
Formulas and Functions50
jhawker
-
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.
It has many application & the proof of concept exists and we use it.
We use it for an approval process (for in…
API & Developers587
JeremiahHorstick
-
Hello,
I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
Formulas and Functions86
MattSederquist
-
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone.
I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies a…
API & Developers318
mschwahn
-
As a Project Manager I need to assign "Non Human" resources to tasks within my Smartsheet project workflow. Some of my project tasks involve using multiple computers for processing. Depending on the size of the project, it can…
Using Smartsheet78
Michael Acker
-
I would like to use a burndown chart to track tasks of projects.
Is there the template for burndown chart on Smartsheet?
Using Smartsheet408
Hiromitsu
-
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a
0.5 story point = 1d,
1 story point: =2d
2 story points = 3d
3 story points = 5d
...
…
Premium Apps and Integrations104
NKH
-
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 Smartsheet209
Nsul
-
Hello everyone,
I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still down…
Using Smartsheet69
Conner Sherman
-
Hi,
I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error.
The formula works perfectly for one crit…
Formulas and Functions154
IBRIEOG
-
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 Smartsheet90
JWattz
-
Sheet 1: Work Scheduled (number of work units scheduled in a given month)
Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month)
I would like to multiply a cell from Sheet 2 with the…
Formulas and Functions813
JoeS
-
Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.
Using Smartsheet308
KMart
-
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 Smartsheet50
Mattias
