-
I need the Form to populate information to different sheets in Smartsheet
Hello Smartsheet community, Could you please advice, I need the Form to populate information to different sheets in Smartsheet depending on the dropdown menu choice. For example, there is a new project enquiry form, depending on the department choice information should be populated to the appropriate department's sheet. I…
-
Sheet Summary % Complete
I am feeling silly that I can't get this to work. I want to get the % complete of my project based on those with the status of "Complete" divided by all columns that have text in it. =COUNTIF(Status:Status, "Complete") / COUNTIF(Status:Status, ISTEXT(@cell))
-
Health ball question
I tried to search how to do this formula, and I feel like I'm really close, however it just isn't right. I am looking to write a formula where it will show the "health" of an error percentage. 0% is green; 1<50% is yellow; 50%< is red Where 0% is green; 1-50% is yellow and over 50% is red. Thank you!
-
Display All unique Level 1 Hierarchy from one smartsheet to another
Hi I have equipment as a column in EQ needs smartsheet and it is a level 1 when expanded I have all the data below it for that piece of equipment. I am trying to make a calculations sheet that will only show all the types of equipment (level 1) entered onto the calculations sheet. When I go to the calculation sheet it will…
-
zip Code Radius Help
Hello Everyone!!! Hope my question makes sense. But I am trying to figure out if there is a formula that can provide me a Max Distance radius from Retailer formula that shows the max range in which we should set our radius targeting for these retailers. I have the retailers full address, Zip, Lat and Long so I feel like…
-
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
-
COUNTIF and HAS functions not working on multiselect columns
Hi! I am having an issue with using the COUNTIF and HAS functions together to count all instances in a select all that applies column. I'm specifically using this on a metric sheet to add it on my dashboard. Any ideas on what I'm doing wrong?
-
Referencing Level 1 Cell Value to a new column
I am looking to make a helper column that copies the value from the Level 1 Parent in my project sheet. If there are several children how do I reference the Level 1 value to copy that value in the entire helper column? First project section: Level 1 "Report Execution" Level 2, 3, 4, children Second Project section: Level 1…
-
Countifs and NOT(ISBLANK)
Hi, I'm hoping someone can point me in the correct direction. I'm trying to get a Count of the amount of unit of a specified category if they are not yet assigned. Basically, I have Column "STOCK" that I want to count what is assigned in box SEARCH201 if "ASSIGNED" is empty. This is what I have so far:…
-
How do I override a cell that is set to Auto Number?
I have two sheets with an auto number column named "Work ID". The rows from one sheet get moved over to the other, and then the new sheet adds children to that row. I need to keep the column set to Auto Number in the second sheet in order to be able to move from the first, but I don't actually want to use the Auto Number…