-
Moving rows from one sheet to another
We use Smartsheet for our production schedule. The schedule consists of 9 sheets that are all in a workgroup. Is it possible to setup a rule that would allow a row from one sheet to be moved to another sheet using the checkbox feature? Thanks, Jim
-
Gantt View - % Complete Column
I've noticed that to have the "% complete" column value show up graphically within the Gantt display, the "% complete" column MUST be a free-form entry field. I have another sheet column that uses the "Progress Bar" type. I was hoping to make the "% complete" column calculated based on the value within the "Progress Bar"…
-
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…