-
If a cell does not contain a period
Looking for the syntax for if a cell does not contain . (a period) This is not working =IF([Work #]1 <> "*.*", "No", "Yes")
-
MULTIPLE LINE (CHILDREN) IN ONE FORM
Hi. I am thinking of automating our Supplies Request using Smartsheet. Inside a Supplies Request Form, you can request more than 1 materials/supplies. What should I do inside a form to make requestor request more than 1 materials/supplies and make it appear in the sheet that there's only one SR form and under it (children)…
-
List of All Forms Associated with an Account
Is there a location within the master account admin to see a list of all forms associated with our Smartsheet account? We need to make a master table of contents (in Smartsheet) so that our internal employees have access to all company Smartsheet forms. Since we don't all have access to every sheet, and we have hundreds of…
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Nested VLOOKUP statement error
I am receiving an error with the following nested VLOOKUP statement. I've included an image that might help to better explain. Unfortunately, I have looked at this so many times and tried so many combinations that I'm afraid it is a simple fix that I am just not seeing. Need to use the number in Details4 cell (in this case…
-
Is it possible to use QR codes in Smartsheet to track inventory?
I have a project that requires tracking inventory and instead of barcodes we are looking at utilizing QR codes. Does anyone know whether it is possible to use the Barcode Inventory Management template that is available in Solution Center but do QR codes instead of barcodes?
-
Editing the Layout in Dashboards
I've created several dashboards where the content/widgets are not static. I'm frustrated by the tedious way I have to move widgets around on the page. I would love it if there was a way to "group" several widgets so moving them around could be easier. Or maybe be able to create a "corral" of sorts, so that items could be…
-
Nest an IF Formula
With the help of the community, I have two formulas that I would like to combine into one if possible. Formula 1 =IF(Ancestors@row = 0, COUNTIF(Ancestors$1:Ancestors@row, Ancestors@row = 0), "") Formula 2 =IF(LEN(RowID@row) = 1, "000" + RowID@row, IF(LEN(RowID@row) = 2, "00" + RowID@row, IF(LEN(RowID@row) = 3, "0"…
-
Contact Formatted Cell --> Autopopulate Info into another cell.
How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts? Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically. Thanks.
-
Auto change status to complete based on start/finish date?
Hello, I've looked through the forums but can't seem to find a formula that works. My columns are status (Not Started, In Progress, Completed, and ERROR). I need the status column to reflect what is input into the start/finish date ex: start date today end date blank = In Progress. I also want to display an ERROR message…
