-
Web form submitted child rows - how to sort them into place?
Good afternoon, I have a sheet where we are tracking time allocated to various projects. Each web-form submitted project is then given a parent/child relationship with the child row being the submitted info and the parent being the summary view of all the children by the same project name. However, when I try to sort new…
-
CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti
I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below. I have 4 current projects and 7 resources. Please see the screenshot for an idea of what I'm trying to accomplish on a Metrics sheet that…
-
eliminate INVALID DATA TYPE when using a IF statement to display the month
I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE. I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE? Here is my IF Statement…
-
How can I get the number of checkboxes checked in a single column ?
Hello, I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case). As you can see in the screenshots, I…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Lookup text or number in last cell
Hello, I know how to do it on Excel, but cant seem to get it to work on Smartsheet. I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.…
-
Renaming Reports - updateReport() functionality
There has been very little discussion on this topic. What is required to get this feature added to the API? I have been assigned the task of creating a JAVA app that will create new workspacea from a set of templates we've created. This is to be done through the JAVA API(SDK). I've completed the app other than renaming the…
-
Delete License User request
A new user at my company inadvertently sent a license request. I can't find an option to delete it. Help?
-
Series of Checkboxes triggers complete
We're using Smartsheets to track our projects through the production process. We have one sheet that is just a list of the items, with 6 check boxes signaling that portion is complete. When all 6 check boxes are marked "checked"/true, I'd like the last column to automatically update as "completed." I've looked around and…
-
Hierarchal columns
I am very new to Smartsheet and have tried to search the community in the hopes maybe my question was already covered, but unfortunately, I did not find anything. I am hoping someone could help me. Is it possible to create a smartsheet like the below created in google sheets? The 1's and 2's represent checkboxes on the…
