-
JOIN formulas
Hi team, Just discovered JOIN formaula - very helpful! However, I can't seem to get it to join THREE coloumns together. I'm using this formaula for joining two which is working perfect: =JOIN([Quantity (m3)]1:[Time required]1, "-") However, when I try and add in another (so a third coloumn) it errors. =JOIN([Quantity…
-
Adjusting Lane Width & Card Height in Card View
Hello! Is it possible to adjust the width of the lanes or the card "height" in Card View? I am currently working w/ 4 lanes and would love to adjust the width of each lane, thus allowing more detail to be shown. The ability to adjust the "height" of each card would be helpful as well...thanks!
-
Shortcut to Collapse / Expand
Hi, It would be very useful to have a shortcut to Collapse / Expand grouped lines, instead of clicking on the little +/- buttons. When using a lot of grouped lines it becomes really tedious to always look for these tiny buttons. Is such a shortcut planned? Regards, Xavier
-
Enhancement Request: Allow "when condition is not met" for Date columns
In order to do some common date related conditional formatting (for example, aging or older than 7 days ago https://community.smartsheet.com/discussion/setting-conditional-format-when-date-eg-more-week-ago), we need to create a formula. This could be avoided if we had the same functionality for dates that we have for other…
-
Arabic Language
hi we would like this platform to support Arabic Language as a GUI thanks
-
Counting current months in a date column
Hello, I am trying to get a count of due dates in the current month, here is the formula I am using and it always returns zero. the formula is in a text/number column and the data is in a date column. =COUNTIF([Due Date]3:[Due Date]204, MONTH(TODAY())) I,m a beginner and could really use the help. not getting errors, just…
-
Biotech or Pharma companies
are there any Biotech or Pharma companies using Smartsheet that I can speak with regarding setting system up. Our finance group set the system up to track POs & Invoices, however Clinical needs the system to incorporate timelines and milestones.
-
CountIF using AND
Hi all, Can anyone tell me what might be wrong with this function below? =COUNTIF((AND([Field CSA]:[Field CSA],"Name"),([Status]:[Status],"TEMP"))) I need to count the occurrences where the Field CSA column has the word Name and where the status column has the word TEMP. When each value appears in their respective columns…
-
Justify Column Names
Hi SS users, Is it possible to centre justify the name of my columns..... Minor detail, but makes my sheet look messy. Cheers, Kylie
-
Unable to Modify End Date in Report
I have a report in which I want the stakeholders to be able to update the start and end dates that are used for resource scheduling on the report and not the Smartsheet with all the raw data. We can modify the start date but not the end date. Is there something preventing this from happening? I cannot change it either as…
