-
Last Modified Values Incorrect
We have a sheet that sends out alerts to a couple hundred people who have no access to our sheet. As people fill out their forms the Last Modified By column changes to list their email. I've noticed that the emails listed there sometimes hop onto other rows, and say someone else had last edited that row when it's not true.…
-
Lock Columns
Hello Everybody, I want to know if it is possible to lock a column for some editors (Editor A) and unlock the same column for others editors (Editor B). Thanks.
-
Populate a STATIC Date column based on another column in sheet
Hi there, I am trying to set a date based on when another status column is set to a desired value. For instance, I want to populate a start date (which will never be changed). with the date that the Request Status is set to "Ready For Processing. I know I can achieve todays date by using a formula, but I do not want to…
-
Adding a row via a form is acting differently than adding a row directly to the Smartsheet
I have a Smartsheet that is a list of contact dates, with multiple entries per person contacted. There are First Contact rows and Followup Contact rows. I have a form to enter the data. I enter the names into a column that is currently set to a single select drop down, but is not restricted to dropdown values. The column…
-
Can a copy of form responses automatically be sent to multiple emails after a user completes survey?
Hello, I work in medical education and am looking for a way to have the results of a filled form automatically sent to multiple emails. Essentially the problem I am attempting to solve is this: We are looking to have medical students receive instant feedback from their faculty supervisors through Smartsheet. Ideally,…
-
Sorting not working properly and I'm under a deadline 😳
For some reason when I try and sort columns in either my sheet or a report based on the sheet, the sort does not work properly. NOTE: there are no hierarchies in this sheet. It seems as if the Sort is not respecting the orders of magnitude. So 36 is somehow senior to 344, for example. At first I thought it was because the…
-
Is there a way to show a parent task on a row-sheet report?
I am creating a report, pulling from multiple sheets, that shows upcoming tasks in the next 7 days. The problem I am running into is that there is no hierarchy shown on the report. I get a list of tasks, but I do not know what 1) sheet they're from or 2) what phase/parent task they are related too. Is there a way to show…
-
Paper Clip isn't showing Up?
Hi - I have 14 attachments on the smartsheet and if I hover over the line, I can see the attachment. but you can't see the paper clip at all on the individual lines? do you know how I can get it to show up?
-
Sheet Summary Report by Month
Hi everyone, I've created a report that we generate every month by choosing to run the report between X and Y date. Simple enough. The report is generated from our master sheet. I have another sheet that calculates some statistics. I.e, number of staff, cost per trip, cost per trip type, etc. Our mastersheet can be…
-
Formula for Contact List Column
I am trying to have two contact list column cells ("Assigned 1" & "Assigned 2") carry their information into another contact list cell ("Assigned To"). What formula would you use in my "Assigned To" (a contact list column)? Or does this need to be a manual task? Thank you for any assistance you can provide.