-
Having a form as an email
I am trying to have a form go into smartsheet once it is completed with the same colors and as the form and also not show that things were updated in yellow. Is there a way to do this?
-
Lookup reference in another row referenced
Hello, Possibly this cannot be done in Smartsheet. I am trying to port over our drawing list coordination sheet from excel to Smartsheet. The formula uses Lookup in Excel - actual revision number to find on the same row that number - then return the date of that column from the first row of the sheet. The excel formula is…
-
Creating a Milestone
I would like to create a milestone where it is within a timeframe I decide to setup. For Example if I put the Start Date as 5/15/18 and a target date of 5/23/18 how can I go about doing this so we can see a milestone.
-
Link limits regarding Vlookup
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is…
-
Is there a way to Center things on forms
Is there a way I am able to center the headings and information or does it always have to be on the left side of the form. I have attached a copy of the form I am using and now I want to be able to center all the information or move around things on the form to have it linear where an email address and phone number would…
-
Making a Date Column N/A unless needed to for a specific row
I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows. For Example: I only want the Delivery Date Column to be active when it comes to Deliveries. Is there a way to do this or no? Please Help Thank You.
-
Is there a way to lock certain items in an update request
I am wondering if there is a way to lock people from editing in an update request certain fields or if I should not have them in the request at all? Please let me know.
-
Linking to another sheet when a certain word is used
I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else. I need help Thank You
-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…
