-
DataMesh - Duplicates In Source Sheet
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of those scenarios, I'm not going to get all of my entries. Is there another way around this…
-
IF formula for RYG balls
Hi I am trying to make a formula that states: If it is 14 days past the TBF date field, and the Reported date field is blank, make the ball Red. If it is 7 days past the TBF date field, and the Reported date field is blank, make the ball Yellow. If the Reported date field is NOT blank, make the ball Green. Nothing I try…
-
Not all fields are being included in the webforms confirmation email
Hello, One of my colleagues brought it to my attention that when they are completing a form and request a copy be sent to them for confirmation, one vital field is missing from the email. It is a numerical field, relating to IDs. The entire field is missing from the confirmation, including the title. I'm not seeing any…
-
Count days between start date and today
I want to count the days between the start date and today if the end date is blank.
-
Average formula
I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will happen when there is no inventory at the moment). Can someone please advise where my…
-
Feature Request: Smartsheet Desktop apps (specifically for Mac!)
Dear Smartsheet Team, PLEASE build desktop apps so that users don't have to rely on their browser to use Smartsheet. If you look at most people's browser, chances are they have a million tabs opened. That makes it easy for Smartsheet tabs to get lost in the chaos, which in turn reduces overall productivity and prevents…
-
COUNTIF Column Totals - Would like to Exclude Two Cells
We have a form connected to our sheet. Form submissions are added to the top. Each column asks a question where the submitter can choose one of three answers: Yes, No, or Don’t Know The Yes, No, Don’t Know totals are at the bottom of the sheet using the COUNTIF formula. We originally set up the formula to include the rows…
-
Is there a way to alphabetically sort collaborators and shared users (when emailing a sheet)?
I have sheets that I want to notify a few people of changes. When I use the email to shared users function it will list all users shared to the workspace first and also users shared to the sheet. It would be helpful to see the list in name alphabetical order so I know I have selected the correct people. I find myself…
-
Automation Workflow broken?
Has anyone experiencing any "Request for Approval" workflow issue? e.g. approval request goes though a workflow that is NOT as defined - the COO is receiving purchase request that does NOT required his approval. Any help is appreciated.
