Discussion List
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…
Creating Sheet from Form
Hi! Is it possible to create a form that will create a new sheet for every form submission? Thanks!
Row deleted workflow notification doesn't provide details
I created a workflow to receive notifications when a row is deleted. I added the cells I wanted in the notification template, but the notification came across without the details. See screen shots attached. Steps: Created automation using 'Alert someone when row is deleted.' Added codes to pull into the notification in the…
Update SMARTSHEET using Power Automate
Hello, I have an updated Excel file, and I would like to transfer new rows of data using Power Automate. I see the ability to go from SMARTSHEET to Excel, is there a way to go from Excel to SMARTSHEET? Thanks, Shahara
How to edit titles in a Cost Tracking Report
How to customize/edit titles and values in a Cost Tracking Report? 😫
Smartsheet has Random rows that are not being send out on scheduled wokflows
There are random rows on a smartsheet that will go out if they are triggered Manually but they are not going out if they are triggered automatically...
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:…
Auto populate name
Is there a way to auto populate a name based on what user checked a box? User checks an column, the column next to it auto records that user as the "checker"
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…