-
Datamesh very slow to update
Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?
-
Concatenate Formula; IFERROR / ISBLANK = To pull all dates where the date columns are not blank
Hi All, I'm stuck on working on a concatenate formula that pulls out all filled in date columns only. Currently unsure how to integrate IFERROR and ISBLANK functions in this formula to pull out only the date columns that are not blank! Would like some assistance on this :) Thanks, Andrei
-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Two jobs in one spreadsheet?
Hi, Thanks in advance for your help. I have two sets of duties within my position: one set as Sustainability Engagement Coordinator, and one as Energy Coach. How can I use smartsheet to track the amount of time I spend each week on work for each set of duties, and track projects on each? Or do I need separate sheets for…
-
Can I turn off the "Used in formula on" information screen?
I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
-
Use Smartsheet API to sync with external system
Hello I have a need to sync Smartsheet with an external system, the only way I can get the data out of the system is via a regularly updated report - however I have no way for the report to not include all data. Ideally the API would give me an option to specify the value of the primary column, and if there is an existing…
-
Conditionally Parsing Values from a Multi-select Cell
Hi! I am trying to create a column formula that pulls only multi-select values which contain the string "ML" from a multi-select column. Here is example output that I am looking for: In this case, "Templates Used" contains the full list, while "Mini Lesson Templates" should only include values from "Templates Used" which…
-
Implement the capability to allow records to be moved to a different row and remain intact
This is in reference to the support case #06202095: https://supportportal.smartsheet.com/s/case/5005a00002WaZM4AAN/issue-with-data-insertion-and-moving-them-see-detailed-description Summary of the case I use a plugin called Smartsheet for Jira Connector to sync data between Jira and smartsheet. The issue is that when I…
-
extract part of a cell's text
Hello, New smartsheet user here. I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another example: Ø18*1000 would return 1000. How do you do this? Thanks!
-
Allow Admin to transfer single sheet ownership
As an admin, when folks leave the company, it is sometimes desirable to transfer ownership of Sheets to different users. Example the person was in HR, some of the sheets they own should go to Recruiting, some to Payroll and perhaps others to Benefits. As the Admin I would like to be able to transfer the sheets on an…
