-
Column Formula not selectable as Gantt Label
Hi Folks, Is this a bug? For Gantt chart labels, I use a column that concatenates and formats the task and end dates; call this column "Gantt Label". I select this as my Gantt label and it looks great. To prevent my formula from getting corrupted or broken, I convert "Gantt Label" to a Column Formula. Here's where it gets…
-
URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL…
-
What criteria use to determine a "current user".
I have a report that surfaces information based on a current user filter. It is filtered on a contact column. The issue is, my users are all over the map with logon ids. We have two sets of emails in my company, internal and external. They all map to the same email client, so to the user it is transparent. In addition some…
-
Taking into account month AND year
Hi everyone, I have two columns. One is the date that the form was submitted, and the other tells us which quarter we received it. Our fiscal year is from April 1 to March 31. This formula works great, but I've realized it won't account for the change in year. Currently, we are in 2020/21, but as of April 1, we will be in…
-
Using COUNTIFS with CONTAINS
When I try to incorporate a CONTAINS into a COUNTSIFS i keep getting errors Works fine: =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA - Daily Job Start Safety Form Range 2}, $Date$1) Incorporate CONTAINS : These are 2 i tried =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA -…
-
INDEX() function help
Hi, I have a master list of tasks in one sheet with project specific labeled columns. I'd like to break out those columns into separate sheets. My thought is the best way to keep the master list current while transposing data, using a combination or INDEX() and MATCH() functions would be best but am interested in any…
-
Help Creating a formula using Children
Hi! I currently am experimenting with Parent and Children Hierarchy to clean up my sheets. Below is a screenshot so you can see my mock up page. The issue I am running into is when I add an additional "Project", my formulas in the columns on the right are pulling from the whole column. I am having difficulty creating the…
-
Today / Yesterday formulas
Hi all, I need to create a dashboard to include all calls made to clients, either today or yesterday (the idea being that the charts would change on a daily basis). My issue is that I don't think I can use the Today or Today -1 type formulas as the date column is NOT a date column type, but a text column type. I can't…
-
Form Information is Not populating in Sheet
Hello, I have a Smartsheet Form set-up that adds new rows to the bottom of the sheet. At 6:30 AM MST 10/20/2020 this feature/feed stopped working. I entered a test form in about 5 pm MST I looked at the properties of the form and it still says last entry was 6:30 am. Yes I have gone to the sheet and scrolled all the way…
-
Copy cell above in formula
I have created this formula: =IF([is Child]@row = "T", [Estimate Number (1)]1814, VALUE([Estimate #]@row)) I am trying to copy the estimate number from the row above if the current row is a child. Works fine until the sheet is sorted. How do I change this formula parameter "[Estimate Number (1)]1814" to copy the cell above…
