-
Add date to formula
Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please…
-
How to add date to formula.
Hi so I am using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Not Started"). I want to also only filter by a certain date. how do I add that. There is another column called "due date" and there are dates in it. How do I only look at stuff due this month by adding it to the…
-
Sum a column of numbers only if they meet certain criteria.
I hope this makes sense. I am trying to add up all the numbers is column "Slides". But I only want to include the numbers if the done is not checked. I also not not want to include the number if column "Status" says Scoring Complete. Column "status" has many different options in it. I only need to total to be in one cell,…
-
Tableau Online
I have a license for Tableau Online and I created a Dynamic Dashboard in Tableau Desktop. When Shared the dashboard to create a Link and put it in Smartsheet always for user and password for tableau. How can I add a widget link of Tableau in Smartsheet Dashboard for my Smartsheet users without asking me the Tableau…
-
Branding smartsheet links
Can i brand all link on smartsheet to my domain link like mapping , for example smartsheet.mydomain.com Thank
-
Data Mesh Not Mapping Correctly
I am trying to do a Data Mesh between two sheets, and it doesn't seem to be mapping correctly. I think this is an issue with the lookup values, but I am not positive. On the Target sheet, the lookup value is the Primary column and there are many multiples in that column. Could either of those factors be causing problems?…
-
Excel Data Extract
Who has experience with Zapier (or another app) that will allow Excel data extract into an existing Smartsheet? Need more functionality than just whole rows. Too complex to accept creation of a new Smartsheet with each Excel data transfer. Data Uploader won't work. Would like to be able to extract individual Excel cells…
-
Dynamic view - date format converting from UK to US
Hi Dates are being converted from UK format in the report to US format in dynamic view, cannot see anywhere in settings to change, can you help? Thanks
-
Document Builder Functionality
Hi, it's my understanding that 'RYGB Balls' column properties do not populate when using Document Builder -- symbols automatically converts to the associated text. I've tried multiple 'fixes' without success. Can you please recommend a workaround until this issue is resolved by the product team. Thank you in advance for…
-
Pivot App - How can filter a field
Hi there, I'm new using the Pivot App and I was wondering if there is a way to filter any of the fields in the pivot table. I have an excel pivot table that I'm trying to replicate in smartsheet from a master data that already is imported into my smartsheet. There is a column in the data master named "Current Status" with…
