-
Update request with job name ( or sheet name)
I have 4-5 jobs ( or sheets) going at the same time. I've sent out update requests and unless I remember to edit the subject line with what job it pertains too, the recipient at a glance doesn't know. They have to click on the request to follow to the sheet. Any way to get the sheet name on there someplace automatically? (…
-
Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
-
Imaginary Row numbers or post level of web forms
Would it be possible to add negative rows that are out of scope of the top of the smartsheet? Being able to reference formulas out of the top of the smartsheet would be useful for formula creation and maintenance when information is being added,changed, and calculated via web form. (could also be done by allowing a…
-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
[Product Enhancement] Improve Update Request Messages - Bundle E-mail, Add CC
Often I am sending an update request to two people who work in tandem - the current system creates two individual e-mails and records in the system rather than 1 e-mail/record that shows multiple recipients - the same way using any other e-mail system does. The current method causes mis-communications and does not promote…
-
Configuring Update Requests for entire sheet
I'm trying to create an Update Request on an entire sheet to send out a scheduled email reminder weekly. I am only able to setup an update request if I select 1 or more rows. Even when I select all the columns in the sheet, the ability to create a new update request is greyed out. I was able to configure this on an early…
-
Order of columns to select when sending email
When I want to email someone, I don't want all the columns sent in the email. I click on the edit columns to select what I want to send. Many times it's just one or two columns that I want to send. However, it is very difficult sometimes because we have a sheet that contains many columns. The order of the columns seems…
-
modify titles in calendar view
I really like the Card view and how you can show different fields or parents of things in the description. I would very much like this to be added to the calendar view. Defaulting to the primary column is very frustrating IMO and makes the calendar functionality almost useless for project management IMHO.
-
BOX/Smartsheet Best Practice
Does anyone use BOX with Smartsheet?
