-
Calculating a number of days from a start date but stop when there is an end date
Hi, I have a tracker sheet for applications that come in and we need to be able to calculate the days when they come on hold. There is a formula already for when it first comes on hold being =TODAY() - [On-Hold 1 (Start Date)]@row but when we receive the correct information we need to take it off hold and would like to the…
-
Years of Service with Company - Date Formula - Help needed
Using this formula to calculate the Years of Service, but the formula is rounding up. For instance, 7/18/22 is returning 2 years of service when it wont be 2 years until 7/18/24 =YEAR(TODAY()) - YEAR([Hire Date]@row)
-
Integration to MS Azure Devops (i.e. TFS)
I want to integrate Smartsheet data to and from Azure Devops, both ways. What is the best way to do that?
-
Report not showing summaries on Dashboard
I am trying to show results from a report I created breaking down IT costs between software and hardware on a SS Dashboard but when I pull the report over it is only giving me the sums for the parent column (division) and not breaking them into 2 pieces for each dept (showing totals for hardware and software for each…
-
Use an IF statement to insert formula?
Is it possible to use an IF statement to insert the correct formula? Based on the hierarchy, I need one formula added for the parent rows but a different formula for the child rows. The individual formulas do work, but not in the IF statement. Wondering if there is a trick that I'm missing? =IF(Hierarchy@row = 0,…
-
Count how many time the same value appears in a row without defining value in the function
I am building a sheet where we log car registration number / car number plate. Let's say there are 3 column for Date, Time and Rego number. I want to make another column that shows how many time the same Rego number has been logged in the sheet without defining the value of what the function is looking for but rather just…
-
How do I add Tasks?
Is there a way of manually adding tasks such as the plus button? + For example 'hire a manager' I want a number row with a + sign Using pro account.
-
Gantt Report Rollup
I'm trying to look at high-level resource utilization across multiple sheets and projects. I have a report that pulls the info by individual tasks, but ideally the Gantt view would show the full timeline of those tasks combined. I haven't been able to figure this out, any ideas?
-
Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Varying) of months to a start date to produce an end date. I have a start date column (which is a date column), a column that…
-
Formula
Hi I need a formula to count a text column but I need to exclude a couple of texts, my formula seems to a bit clunky I am getting a #UNPARSEABLE error =COUNTIF ([10/06/24]3:[10/06/24]548, "<>AL - ANNUAL LEAVE", "<>PH - PUBLIC HOLIDAY", "<>RDO - ROSTERED DAY OFF", "<>WEEKEND", "<>CL - CARERS LEAVE", "<>SL - SICK LEAVE",…