-
Formula - Completed projects in a given year
Hello, The formula pasted below works great if I want to count the number of projects completed in a year. How can I revise the formula so that I can count the number of projects completed in 2020? Thanks!
-
Want to know how enabling Smartsheet WDC to Safe List in Tableau Server Impact its performance.
Want to know how enabling Smartsheet WDC to Safe List in Tableau Server Impact its performance. Want to know how it works (pull data from smartsheet to tableau server ), about its API and how much resource of tableau server it needs to work.
-
if formula help
I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
-
Help us design API classes that meet your needs
Hi, We are preparing new courses related to our Smartsheet API, would you take few minutes to let us know what would you like us to offer by submitting this survey: https://tinyurl.com/ycg7arps?
-
Date Stamp
Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle. I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date column to capture the date stamp when something is selected from the drop-down list. Is this…
-
Branding smartsheet links
Can i brand all link on smartsheet to my domain link like mapping , for example smartsheet.mydomain.com Thank
-
Sorting Rows
Hi, I am working on something that requires to sort the Smartsheet based on a column. The type of column is 'TEXT_NUMBER'. 1/0/12 1/0/1 1/0/14 1/0/3 1/0/11 After sorting the smartsheet with the above column the result is this 1/0/1 1/0/11 1/0/12 1/0/14 1/0/3 I am using python sdk in my project, but it doesn't sort all the…
-
Wildcard
Hello All, I feel like a lot of the issues with Smartsheet functions would be fixed by adding a wildcard function. Are there any talks to incorporate a wildcard function to Smartsheets? Thanks
-
Sum Column Divided by Two Summed Columns
This is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor hours] + [Repair labor hours (return trip)]:[Repair labor hours (return trip)])) Here is what the data looks like: I need the…
-
Notifications to unshared users?
Is there a way to set up notifications for users who aren't shared to a smartsheet? Our HR team is trying to set up automated emails to send to employee/manager email addresses in cells for the Status Change Form SmartSheets that we have and for the new Education Reimbursement SmartSheet that we have so that we can keep…