CAS
CAS
Reactions
Discussions
- Is there a limit to the amount of characters for each drop down option? it appears to be around 40 characters and its pushing the text over to the next line.
- Hi I'm trying to work out a formula for identifying duplicates in a invoice column. what formula would i use and do i setup a separate column to populate the answer to the formula? my column name is '…
- I have a priority column I have a invoice date column I require a formula that changes the priority: to high for anything over 90 days old of the invoice date To medium for anything between 61 - 89 da…
- I'm setting up my first data shuttle config... I want to set up a workflow that onloads specific isolated data from a Excel file on BOX and i want it to update the spend column on my smart sheet. The …
- Hi guys, I'm progressing with my basic formula however what do i need to add into the below formula as an example so i don't get the unsightly #invalid data type in a cell just because the start date …
- Hi, i would like to count the number of yes's in a column with a corresponding service line in a separate services column my first column has three drop down options yes/no/NA and i would like to be a…
- Hi I'm trying to use COUNTIF to create a percentage average driven from columns where yes/no/NA are entered can someone help?
- Hi, i have an alert set up for when a specific field has any value entered it sends an notification to recipients. This works fine but only when no attachments are on the row. If an attachment is adde…
- Hi, I've created a simple formula for showing saving against two price columns that then gives me the final value in a third column. =[Moreton - First Quotation]@row - [Moreton Final Quotation]@row Th…
- Hi I'm getting a #divide by zero message when attempting a simple AVG formula below: =AVG([Total Percentage Score]191:[Total Percentage Score]207) The data is simply showing tasks that are 0% or 100% …
