-
How to auto-refresh the datamesh vlookups?
Hi EVeryone- I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need to go to datamesh website and refresh the rules my self. Is there anyway I can automate this so everytime I dont have to go…
-
Issues assigning tasks to non-licensed users
We are at the beginning of our Smartsheet implementation and are having issues with assigning tasks to project team members that do not have Smartsheet licenses. The error we receive is: The user never receives the email referenced in the error message so they are unable to proceed. Have any of you run into this issue? If…
-
Flagging Red using two conditions
Desperately trying to find a formula that does this: if due date is past and checkbox is blank then flag red in Symbol column For Row 15, tried this but it is not parseable. I used this formula in the Flag column =IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1) says UNParseble
-
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?