-
Auto populate worksheet through hyperlinks built with web forms
My objective right now is optimizing my worksheets to have as little human interaction as possible beyond entering inputs. To that end I have users input their data through web forms to populate my sheets. My issue is that I cannot generate hyperlinks automatically on the new rows created by the web-form. I have…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
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…
