I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the t…
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. …
Hi I want to append/consolidate sheets in smartsheet in a master file or separate sheet all the sheets are the same but for different locations im using forms to collate the info because the forms are…
Evening all. Problem that I have is that I need a dynamic dropdown working between two sheets (i.e. values in column X in sheet 1 should be dropdown options in column Y in sheet 2). I've figured out h…
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progressio…
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to …
Having trouble getting the combination of INDEX(COLLECT)) functions to return the correct data. Is there a "Debug" tool similar to that available in Visual Basic that allows you to step through the fo…
Not sure if anyone else has noticed this yet, but I recently upgraded my computer to Windows 11 and have noticed that working within Smartsheets is a little laggy. Pages are loading perfectly and quic…
I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else…
French Spanish Italian German Chinese Japanese Thai Vietnamese Any advice on using forms in other languages? The only solution I could think of was to create the questions all the languages and paste …