-
How to setup a quotation number request feature?
I would like to set up a form where the users will enter the details of a given, and submit. An automatic sequential number is to be assigned to this entry and notified to the user who sent the request using the form. Is that something that can be done with smartsheet?
-
Project Sheet: Formatting Parent Row based on Children
Does anyone know a way through formula and formatting rules to highlight a parent row cell (finish) if any of its child rows have a blank value in finish? We want to avoid the parent finish date looking deceiving in reports when only some of the children finish dates are known.
-
Compressed (zipped) Folder is invalid
Hi, Since last week if I want to open the zip folder from the download backup link it gives me the following error. Please assist. Y
-
Cell Linking Ability to Filter or Sort Source Sheet / Source Sheet does not stay filtered
All: I have looked but cannot find other questions regarding this topic. Apologize for any redundancy; and, thank you for any help on these two topics. Sandy Ability to Filter or Sort Source Sheet: From my (master) destination sheet, I click cell link icon. Then, I select my source sheet. Is there a way to filter or sort…
-
Send Row Default Fields
Greetings, Will there ever be an option to save the "Send" (by row) "Include" options to be reused. I found a work-around to create a report with only the pertinent fields, but this is unwieldy. Example: When I have a support ticket to answer, I do not want all of the fields to display in the email and going through and…
-
Ghant Chart with quarter headings
I really like the quarterly level ghant chart. However, when the earliest task begins near the end of the quarter, I have two months of blank ghant. I thought that I could force it to show only the part of the quarter that has a task by specifying a date range. But, I still get the blank part of the quarter. Is there any…
-
Card View Settings Help
How do you make adjustments to Card View Settings after you have created a field? Also how come unchecked fields still show up in my cards?
-
Formula to get averages from one column if another column is checked
Hi All! I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups). What I need to do now is…
-
Best way to share specific rows for edits
Hello - I have a SmartSheet containing several rows with thumbnail images and product information. Hundreds of additional rows will be added as the year progresses. I will need clients to review and add information for groups of rows at a time. As to not appear overwhelming, is there a way to only share the rows that are…
-
Naming a Cell
Can Smartsheet let you "Name" a cell, like in Excel? This would be really useful. You could name certain milestones like "Launch Date" and then automatically calculate the dates of other tasks by subtracting/adding from that. For example, the due date for "Approve Launch Publicity" could be =LaunchDate-14 Today you have to…
