-
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…
-
Copying Date to Text Cell
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 then Copy the date the item was created into a text Column. Is this possible? Thanks!
-
Referencing a flag column in a Function
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 if the parent row has a child that is a follow up item. The other (Follow Up Item) marks if a row contains "follow up" in…
-
User Unsubscribed from Automated Workflow
Hi I have set up automation on a sheet to email spacific people when lines are added, some of them have complained they are not recieving the emails and when i looked into the Activity Log it shows User Unsubscribed from Automated Workflow. When I checked with the user they dont recall doing so and were actually Out of…
-
Project Intake Sheet looks correct, Project Metadata and Project Plan missing reference
Hello all, I'm new to SmartSheet so still learning. I'm using the PMO template which makes sense so far, as per the instructions. If I understand the functionality right, information feeds through from Project Intake Sheet to the Metadata and Plan sheets in the specific project folder (ie. Project Name feeds through to the…
