Sign in to join the conversation:
I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6)
Yeah, I am an extreme rookie when it comes to this stuff.
If you import the file, there is a box you can check to include formulas. It would seem that it should then be imported.
If you want to rewrite it yourself, you need to be aware that Smartsheets references the column names.
Just substitute ColumnTitle3 for A3 - and so forth and so on.
But if your column names contain spaces or end in a number you would surround that name in brackets.
Column A - Row 3 would be [Column A Title]3
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine. I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I…
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
