Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and…
In my metric sheet, I am receiving the #INCORRECT ARGUMENT SET error on code I made trying to only count the child rows in my reference sheet. =COUNTIFS({Is it implemented?}, 1, {evidence attached 1},…
I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my resul…
Hi all I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of anothe…
This is going to be hard to explain, but I'm hoping I can do it. I have a sheet named "ProjectSheet". Under Task Column I have multiple "Applications". Under each Application is a Project Stage (Data …
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to…
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partne…
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns…
I am trying to create a workspace with multiple spreadsheets that will transfer rows back and forth from one to the other automatically. I have a sheet for inventory, one when the equipment is assigne…