-
Countifs and OR statement
I'm trying to have a formula that will work if one column matches specific criteria and then if another column matches one of two criteria. I have been able to get it to work for one of the criteria from the second column by writing =(COUNTIFS({Assigned Owner}, [Assigned To]2, {Project Progress}, <>"Closed")) However,…
-
Calculate the total rows but exclude the same name
What kind of function combination that i can use to calculate the total row but excluded the same name, as follows (green highlight).
-
Report Builder - 'Who' Functionality
Hello, I'll preface this by saying that I think the answer is no, but I wanted to check for other people's thoughts. In our project plans, we have a Project Manager field that lives in a Contact type column. There are many projects we run where we have multiple Project Managers assigned. Each PM has their own dashboard for…
-
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…
