Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Smartsheet Merge search
Is there a way to search when selecting rows during a Smartsheet Merge?
RYG(B) Balls - How do I reference the value of child cells belonging to neighboring cell/column?
=IF(children([Finding Status]11)="Closed", "Blue", "Yellow") The above attempt is failing me (i.e., "missing or invalid parameters"). Any advice? Thanks! John
dealing with distant dates
Hi everyone, I really need help here. My project is of the long sort (several years). I seem to have a problem with far away dates: smartsheet won't 'take' a date in 2018 (I type it or select it in the calender and the box goes blank). My other question is: how do I hides dates (I don't need the next few months on the…
Pairing with Epicor
Good morning, Other than downloading a Smartsheet into Excel and then uploading to Epicor, is there a way to directly integrate the 2 systems. Thank you, Lisa
Signatures on documents
Does Smartsheet have a Docusign options? Want to be able to email documents to get a signature.
COUNTIF Formula for Week Of
I am trying to do a COUNTIF formula of a list of cells that contain dates to determine if any of those dates end up on a given week. I think I need to use COUNTIF and then have a > and < on the date but am not sure how to do this. I could also reference the Monday DATE() +4. Anyone have any ideas?
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
Multiple currency columns thousands separators
We have a sheet with multiple currency columns, EUR, GBP, AUD etc. Is there a way to define thousands markers? Currently it seems to be defined by user account setting, which does not work for us as we need EUR with "dot" separators and AUD with comma separators.
Reports / Master Calendar
Hi there, it's me again. So here's the thing... We are a small test facility. We are trying to track jobs that are nothing like eachother using the same equipment and people resources. Sometimes we have 2 people resources on the same job. I know there currently isn't anyway to put 2 people on the same job and that I would…
Changing column to a "List"
I have a column that has equipment in it, it is set up as a text column. I am using the information in that column for conditional formating. Now I want to make that column a list to choose from and I can't because of the conditional formating. Do I have to un-do all the conditional formating to change it to a list column…
