-
Cross Sheet Joining Automation
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. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
-
Can you append sheets in Smartsheet like you can power query in excel/power bi
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 site specific I want to combine the two sheets below as example in a master sheet and at the same time the master will…
-
Data Shuttle - trigger workflows with new row in sheet
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 how to do a workaround using Data Shuttle (offload workflow from sheet 1 to a Smartsheet attachment CSV, update dropdown in…
-
Automatic Linear Percentage Complete Formula
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 progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Smartsheet count function
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 count that line?
-
Does Smartsheet have a Debug tool?
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 formula? Thanks in advance.
-
Impacts of Windows 11 Update
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 quickly, but interacting with and entering content into cells, formatting, column and row functionality, etc. is a shave slower.…
-
Collaboration in Smartsheet (Saving)
Hello, I am just wondering what is the best way to work in collaboration on smartsheet. Currently when multiple users are working in the same sheet and one clicks save the other users data is lost! How do I prevent this from happening. What is the best way to guide the teams on how to work with each other effectively.…
-
Automation Suddenly Not Working
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 having automation problems??
-
Can Forms be generated in the following languages?
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 an image of the question in all languages at the top of each section of the form. Can you even paste an image into the…
