-
Automatic roll up of the same Field?
I have an internally corrupted data base. Our people have been inputting the wrong/random ID numbers for the same Model #. I exported some of our data from our database into a Smartsheet to see if I could sort them. Below is snip of a 20,000 row sheet that I want to organize by model number and have all the same Model #'s…
-
Updating rows with multi_contact cell?
Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…
-
Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…
-
Can you automate attachment exporting?
We can export sheet data automatically using tools like Power Query but is there a way to get attachments out of smartsheet and into our server? Or is this something that needs to be done by hand? Thanks
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
-
Is there an automated workflow that populates data in cells based on triggers and conditions?
Hi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -
-
translating Content
Hi all, Looking for any ideas, I am working on a sheet that is being used in 10 countries, currently, we use English as the main language, however, content can get lost in translation. is there any way for users to use their home language on a sheet and then translate it into English on a master sheet. I have looked at…
-
OFFSET Function
Hi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equivalent would be in Smartsheet. What I am trying to get at is this:…
