Discussion List
Why are my reports pulling in other informataion
I have a report that I have filtered to pull in tasks for individuals. It's supposed to pull in any tasks that do not have a status of 'Complete' or 'Not Needed' but multiple tasks are pulling in that have been completed for many months. How can I fix this? Report:
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
Why is my auto number column not populating
I create it. It's blank. Add new rows, they are blank. I've tried deleting and recreating and this is nothing but a blank field. I have specified starting number.
is there a word-count formula?
I have a cell where I need to know how many words there are.
I need help to complete this formula
=COUNTIFS({Sunbelt Life Cycle TC tracker Range 1}, "Complete") I need to pull in this data but I need to pull it between certian dates ex.. 4/1/2024 and 4/30/2024 can some one help me please
How to convert text in the form to become contact list to set alert
we created smart sheet using FORM. One of the field Requester where we colleting Email id as Text format but when we creating the alert this Email id not showing in the cell in contact list
OR Statements
Can anyone see the error in my formula. =IF($Help$1 >= April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE(2024, April$1, 31), {888 - Job Progress Origination Note}, = "Spec") + COUNTIF(OR{888 - Job Progress Final CO}, "", {888 - Job Progress Final CO}, >Date([Help Lot Size]1, March1,1)) + COUNTIF(OR({888 - Job Progress…
Group WorkSpaces and organize them in "folders"
I would love to see a way for us to be able to "Folder-ize" WorkSpaces that have been shared to us by others. To be able to group those WorkSpaces by the department that it belongs with to make it easier to find and to support. Especially for those of us within our District who are the ones responsible for training and…
Date formats
I have a date that is coming into my sheet via the CRM connect and the format is M/DD/YYYY. I need to create a formula that calculates 2 weeks prior to that date but cannot because Smartsheet does not recognize that as a correct date format.
How do I get the Move and/or Copy Automation to work properly?
This automation with work for a short period then stop and show me this error. Of course there is going to be a matching a matching column. How do I avoid it?