-
How to Stop formulas from changing globally
This is my formula... They look fine across the first row... But if I copy the formula to another row and change the reference, all the cells change. This is NOT what I want. Can anyone help?
-
Why is my automation to copy rows to other sheet missing data from certain columns?
I have an automation created that, when a row is added to sheet 1, the row is copied to sheet 2. Its working fine except it sometimes misses values from the "First Pay Date" column and the "IC" column and they dont get copied over. They will just be blank on sheet 2. I made sure that under column properties, they are setโฆ
-
How to Count number of boxes checked in a date range, Cross sheet formula
I am needing help with a cross-sheet formula to count the number of boxes checked if the date column is between a certain range. My current formula looks like this: =IFERROR(COUNTIFS({Checkbox column}, =1, AND({Date column}@cell >= DATE(2022, 9, 1), @cell <= DATE(2022, 12, 6))), "") however I only get a blank entry or anโฆ
-
Sub-Report
I am looking for a way to create a sub-report within Smartsheet reports. I currently have a report that shows all the information about jobs I have going to the manufacturing floor. The "M" number under the Primary column is the job number. This is fed from a sheet that hold all the relevant information. I have a secondโฆ
-
Count tickets created in a specific month
Hello all, I am trying to setup a formula for all closed tickets based by month. I tried to make this formula below work but it's giving me a 0 count. Can someone please help? My criteria is for the ticket to be closed and to fall under a certain month. =COUNTIFS({All Tickets Range 1}, "Closed", {All Tickets Range 2},โฆ
-
Creating an Outline value
I am trying to create an Excel export from my SmartSheet project plan for the purposes of importing select tasks into an internal PPM solution. One issue I have is the lack of an Outline field, just like we have in MSProject. Has anyone tried and succeeded to create a column within SmartSheet that can automatically createโฆ
-
Can I auto-populate a cell with available license numbers listed in another column, sheet or report
We share license numbers and they are issued manually now. The process is, we look at the required dates, usually about three weeks, then look to see which license numbers are not in use during those dates and manually assign it. We would like to automatically assign it with a number not in use during the required dates.
-
Return multiple values in 1 cell in Sheet Summary Field
Hello everyone, I am trying to create a sheet summary function. In my column there are 2 people who can be assigned; Tom Jones and Susan Smith. I can get the formulas to work for how many are assigned ONLY to Tom or ONLY to Susan, but I can't get it to work when things are assigned to Tom AND Susan. Any suggestions? I'veโฆ
-
How to Group/Summarize Reports with Row Limitations?
Hello, I have created a report to combine two project sheets together, so I can verify the project schedule. However, when I go to either group or summarize the data I get the following message and then all the data disappears. How can I work around this issue? Thank you, Sheri
-
Formula
'm trying to create a formula for the below information: find if in a range of start dates and end dates of a specific job, one or more of these dates correspond to the current week date if that's happen the guy is not available otherwise is available for this week thanks