-
Automation and Multiple Outcomes
Hi Is there any way, within a single automation workflow to have multiple outputs? What I mean is I have a workflow that triggers when a cell value changes to a certain value (e.g "Approved"). I then want to have a date entered into another cell (easy enough) and also then generate a document to send to the original…
-
sorting problem
i have a problem with sorting, the values look like this; 2615-SL-5306 Here is the problem; I have 2615-SL-5306, and then 2615-SL-7001. 2615-SL-6404 is coming after 2652-SL-0038. It should come after 2615-SL-5306. also, i'm adding a screenshot; you can see that 2610-SL-0301 is coming after 2652-SL-0038. I am sorting…
-
Increase sheet row and column limits
Hi Guys, What is the possibility to increase the row (20 000) and column capacity? I'm working for a company that headcount surpasses the 20 000 mark which makes it extremely difficult to utilize smartsheets, which we really want to do. This would truly make a huge difference in building a database etc.
-
Calculate time between start date and today's date
Hello, Having trouble with creating a formula. I would like to calculate the number of days between the following two columns: Created Date & Today's Date I have a third column called Days Open where I would like the calculation to automatically generate each day. Can anyone provide me with a formula that would work for my…
-
Publish Dashboards with AI Generated Charts & Graphs
I have a published dashboard that is viewable by anyone in my org with the link, but they are not able to see any of the AI generated charts / graphs on the dashboard. Any ideas here?
-
Unable to Add Smartsheet Tab in Microsoft Teams – "Forbidden" Error
Hi. I'm experiencing an issue when trying to add a Smartsheet tab to a Microsoft Teams channel. Every time I attempt to add the tab, I receive the following error message: {"message":"Forbidden"} To resolve this, I contacted Smartsheet Help and was advised to ensure I have the necessary permissions. I’ve been granted the…
-
Nested SUMIFS / OR / WEEKNUMBER functions
Hi, how can I combine these two functions? They are both working separately for me for the same range of data. =SUMIFS({MGHours}, {MGNum}, OR(@cell = [Project Num 1]@row , @cell = [Project Num 2]@row , @cell = [Project Num 3]@row , @cell = [Project Num 4]@row )) =SUMIFS({MGHours}, {MGDate}, WEEKNUMBER(@cell ) =…
-
Filter multiple sheet entries to display graph/total quantities on a dashboard
Hi Team, I have a sheet that is a total list of materials used on a job, divided into columns showing material type, size, length, quantity. Each day materials are removed from the store a record is entered into the sheet. I am wanting to display a summary or total of each type of material on a dashboard. I'm open to ideas…
-
Primary column data to other Sheet
I have 2 sheets, Sheet A has Primary column and I want to copy Sheet A primary column to sheet B. Sheet A has 2000 lines in primary column also whenever I update Sheet A primary column I need it should be updated in Sheet B too. how I can do this in Smartsheet?
-
Unable to remove user available in a SmartSheed Contacts list
I created a Contacts list column that additionally had 4 people including myself. I then created a record as an example, using my name. Subsequently I deleted my name from the list and changed it to only allow the available people in the list to be selected. Now I do not show up in the column properties list but still show…