Solution Center
Discussion List
-
Having Issue with "COUNTIF" returns "0"In Formulas and FunctionsHi 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…Answered - Pending Review 21 views 3 comments 0 points Most recent by Malaina Hudson Formulas and Functions
-
Can you automate attachment exporting?In Using SmartsheetWe 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?In Formulas and FunctionsOur 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 …Answered - Pending Review 28 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Dashboard Widget DividersIn Using SmartsheetIs 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.
-
Assigning Multiple ResourcesIn Using SmartsheetI've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at…
-
Is there an automated workflow that populates data in cells based on triggers and conditions?In Using SmartsheetHi 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 -Answered - Pending Review 37 views 5 comments 0 points Most recent by Edwina Sampler-Wright Using Smartsheet
-
translating ContentIn Using SmartsheetHi 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 languag…
-
OFFSET FunctionIn Formulas and FunctionsHi, 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 equiv…Answered - Pending Review 25 views 5 comments 0 points Most recent by Heather D Formulas and Functions
-
Report builder - Collapse and Expand RowsIn Using SmartsheetHi, Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have? I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so bec…
-
Dynamic View: Un-editable FieldsIn Premium Apps and IntegrationsI am having an issue with Dynamic View treating (random) editable fields as "Read Only." In this instance, Dynamic View is treating a Date Field as if it were a "Read Only." In the first screen shot, you will see that t…Answered - Pending Review 38 views 6 comments 0 points Most recent by Genevieve P Premium Apps and Integrations