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 …
Hi everyone, Is there any way for a formula or automation workflow to automatically copy/insert a date into a text cell? I'm trying to create a formula where if the STATUS column is "DATE" it will the…
Hi everyone, I'm currently in the process of adding functions to my task list. I have two columns that I am trying to edit the functions of. One, (Needs Following Up) has a "priority" symbol to mark i…
