-
Countif with Dates, Smartsheets keep adding blank lines, Invalid Data Results
Hi Guys, Firstly, thanks for the help. I am trying to add records and have cumulitive counts based on dates. I am counting the date column of the new input lines with the following formula: =COUNTIF([Created Date]:[Created Date], TODAY() - @cell < 7) for Records added in the last 7 days and: =COUNTIFS([Created…
-
Converting Numeric Values to Days
Hi, I would like to input a quantity in a cell and use a formula to convert it into days of production. I have accomplished this with the exception of the Duration column does not convert the numerical value into days for the Gantt chart. Please help. Thank you, Dennis
-
Project Parent Hierarchy not shown in PowerBI
Hi there, I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up…
-
Recurring task with a checkbox and reset?
Hello All - We currently use a smartsheet pipeline to track our clients progression through our service delivery. This serves us very well. One area that we need help with is scheduling and tracking phone conversations. I have looked into coordinating a crm to schedule and call, but I am not thrilled the tracking…
-
Smartsheet Team Plan Offline and No Response from Support
Last week we cancelled a recurring PayPal payment approval on the PayPal site, so that we could register a different card as our preferred SmartSheet payment method for our annual plan. Although we didn't make any changes on the Smartsheet website itself, our Team Plan instantly disappeared and all Users were downgraded to…
-
Multiple Column Confirmation Criteria to return date from "Order Date" Column
I need a formula for a date formatted column that must return the "Order Date" from the ODate column if the Site Name (Site) is Oak Village, Block Name (Block) is Block 102 and the Floor Level (FlrLvlUnt) is Basement Level. I managed this multiple criteria lookup with SUMIF for number values, but have been unable to do so…
-
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
-
Software uses
Is there any construction companies out there that use Smartsheet other than for job tracking and HR? Maybe budgets and scheduling manpower? I need some ideas on how to set up those activities on smartsheet. Thanks!
-
Use Smartsheet row data to populate a Template
I am looking for a way to automate a process to take data from a single row in Smartsheet and populate a template. Working in the construction industry, processes are slow to change and we still need to PDF documents for communication with our customers (RFI's, Change Orders, etc). I have setup the forms and procedures for…
-
SEND REMINDER ONLY IF TASK IS NOT COMPLETE
How do I setup a reminder to only email if the "Complete" box is not checked off? It seams that there is not a way to add a condition in the reminder setup.
