Discussion List
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…
Automated workflow
Hi, is there a way to import an automated workflow from a sheet to another sheet? Or I need to create it in each sheet?
Form responses for a sheet that's no longer there....
Hello Not sure how to navigate this one. I am receiving form responses when people fill in a web form... but the sheet that it relates to is not in Smartsheet. I think it may have been deleted previously by a member of the team who has moved on. Is there any way of either recovering this file (it's not in my deleted items…
% Completion Formula based on drop down status
Hi there, Help needed! I need to report a % completion rate based on the status of a milestones column where a number of actions/milestones need to be completed in order for the formula column to indicate % status. Is there any formula that I could use to read the status drop downs, and auto fill a % completion rate in the…
Cant figure out Summing 2 columns based on text in another
I'm trying to sum up two budget columns, based on the budget type in another column. For some reason I keep getting errors and can not figure this out. =SUMIF(Program:Program, "BDM", [PO Raised]:[Planned, not POd]) Program Column = Text/Number = "BDM" PO Raised & Planned, not POd columns are also text/number columns that…