-
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
-
Linking from a sheet that's reached the 5000 row limit
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximately 100 field employees. My sheet is up and running and is being rolled out to a limited number of supervisors during the…
-
Gantt Chart Due Date Flag / Milestone
Hi, Is it possible to show a 'flag / milestone' as well as the duration bar on one line of data. I would like to have a due date associated with a task, as well as a duration. Such that I can see instantly how close I am to a due date. Thanks
-
Tracking overall attendance to event
Building 2 different pages, one for general registration throughout the year, another to Track which companies have been to which events. The Registration is coming easy but how do I get it to fill in the Tracking sheet/report? So the Registration will track all the attendees for an event, of which there could be 1-10…
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
Prefill Webform with QR Code
Hi all! I've been playing around with webforms and data stored in QR codes for my company. What I've got is when I scan a QR code, it sends me to a Jotform survey that pre-fills fields from the QR code into the form fields. For example, the data stored in my QR code looks like…
-
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…