-
How can I get a form to link to my project?
Hi Community! I'm a new user and have been reviewing topics and training classes but need some additional assistance. I created a form for users to request a new project, depending on how it is filled out it will route to a specific department to view it via an email. This information will be captured on a master sheet.…
-
User Portal v Update Row v Form with URL Query v??
We need to collect data from over a thousand volunteers on an annual basis. Last year, we collected the basic info using forms. This year, we would like to get the returning volunteers to confirm or update their basics and request new information. Objectives would be a) to collect/update data in one fell swoop, rather than…
-
Counting Rows based on Date
Countless efforts consulting the community and using many of the recommended solutions continue to yield #unparseable results. I have a sheet with 2,000 rows. there is a "Begin_Date" field, formatted as a date field. I want to count in a separate sheet the records in the first sheet that fall on or after July 1, 2021. In…
-
Build report off activity log data from a Sheet
I know that I can download an activity log from a Sheet, but is there an easy way to build a report off the activity log data? I want to track metrics like # of sheet views, unique users using the sheet, usernames in the sheet, etc
-
How can you share a report without giving access to the sheet?
I have created a time tracking report for all employees utilizing a weekly form each completes. As I don't want employees viewing other's time, I created a report for each employee so they could see their own time collectively and make changes if needed, however it only works for the members of management that have access…
-
What controls the formatting of sheet names in a report?
I want to get them all consistent. I don't care if it's a really weird workaround and not a built-in feature - is there ANY way to edit whatever they are based on? Do they adopt the formatting of a particular cell or something? Thank you.
-
Automated reminders are coming from users instead of Smartsheet Automation
Hi all, I have notifications set up to come from Smartsheet Automation, but when the notifications are sent, they seem to be coming from users (I assume the triggering user). Any ideas? How can I fix this? Thanks.
-
Can forms return the label and help text in email to person entering the form?
I have a created a desk assessment and in the form provided some assistance options to better the evaluation. Example … Question is longer than the column header so I've put it in the Label as this … Is the Keyboard separate from the screen? Response options are Yes / No / N/A, but in the Help text - I've added Further…
-
Shared Work Sheet
Q1) When I insert a new row, the cell is automatically in pink color, is there a way to make it white? Q2) Also I have share sheet with a colleague and when I update formula or make changes to the Masterfile, why doesn't his update automatically? Q3) Also when my colleague tried to edit his End date, it wouldn't allow him…
-
Image widget - will not link to a sheet
I have added and image in my dashboard and would like to add a link to another dashboard - in advanced options I have selected Open a Smartsheet item, I have selected the dashboard I would like to link but there is no Save button, I have tried to double click…I can save/link??