-
Column Properties
Hi Community! Is it possible to only allow for a single type of text in column cells and not any other type? For example, if I choose the column property as a date, can the cell restirct the text in the cell to only allow for dates? This is done in Excel using data validation. Please help! Thanks, Dave
-
Asigning special dates in Time Line Display
What I try to make is: E.g.: There is a task for the time between Aug 5th 10 and Aug 18. On Sep 14 partner XY is required to be present in City AB. Is there a way to show the alert icon in Time Line Display linked to additional details? The notification is already possible and the message can be sent to appointed person.ā¦
-
SUMIFS with a date range criteria?
From a project sheet (with additional columns added) I'm trying to tally up the number of days by resource assigned to each quarter. So I want to specify a Q3 date range between 6/1/15 and 8/31/15, for example, as one of the SUMIFS criteria so that I only toal the number of days during that time frame. Something like so:ā¦
-
Update start date with report
Hi all a quick question from a relative newbie: I am setting up a project sheet and want to be able to issue report updates to our outside contractors on a project. I am struggling with a feature in smartsheet. I would like to have my engineering firm provide a start date on a task with a dependency without having toā¦
-
find deleated items
I am looking for a way to track items logged on a web form or a way to find if a line item has been deletedĀ
-
Web Forms and Contacts
PLEASE develop a way for web forms to recognize contacts when you want to include contact names in the rows that are added to a Smartsheet! It just makes so much sense and would be so helpful! Right now, we're left to enter in the webform data, then go back into the sheet and re-type the contact person's name so that itā¦
-
URL to jump to a row in a sheet? Unique identifier for sheet-row combination?
I am looking for a way to have a URL that will allow me to jump from an external source to a specific smartsheet row. For example, if I were to have a Google Sheet which I was doing some calculations and I wanted to have a link corresponding to each row in a Smartsheet to let me click on that link and go directly to thatā¦
-
Reference a row by Task Name instead of by the row Number.
Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from proejct to project so I cannot reference the Row Number. The formula is pretty simple. I have a Completion Date column and aā¦
-
Multiple choice questions in web form
Is it possible to create a question item where the user can select more than one answer - using the standard Shift or Ctrl keys - or some other way? I'm setting up my first Smartsheet ... Thanks.
-
Separate effort and schedule for project planning
Hi folks, I am wondering people's experiences creating project plans that include separate estimating and tracking of effort versus schedule. A simple case has a task done full time, with full resourcing, with no delays or wait times. In this case, the Smartsheet "duration" works fine for both effort, duration, andā¦