-
IF OR Statement
Hi There! Looking for help to on an IF OR statement. Want to take two columns that will be either Yes or No, and populate another column with a date from two columns if it is Yes. Process, either the Facilitator or the Architect will be requesting a Complete By Date. Whichever requests, the other has to say yes or no. For…
-
The SMARTSHEET FIND FUNCTION
We use the "find" function every day in the selected Sheet - using Control-F to bring up a search box. However, this function is unreliable - it doesn't always highlight the selected row in which the search has been asked to look for. This function needs a little tweak to make it more user-friendly.
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Searching on Mobile App / Work Apps
Hi All, Is there not an option to search within a report via the mobile app or work apps? I see that there is a search function included within sheets, but I cannot seem to find an option for reports. Is this really the case or am I missing something? Thanks
-
Hyperlink to a cell in the same sheet
I have a project plan in progress and we have to add additional tasks as change orders which I am adding on the bottom of the sheet so that I can keep the estimated duration separate. However I also want to keep track of these activities within the main project so that they are included in the group of activities in the…
-
IF Formula for Today's Date between Two Dates
I'm trying to create a formula that is only triggered when today's date is between two dates. Otherwise, I want it to be blank. I want the dates to be in the cells and not just in the formula. I use this year over year and it will be a lot faster to change them for next year. I get Invalid Operation when I use the dates in…
-
Transfer ownership to another user using API.
We have requirement that we need to transfer ownership to another user using API. I didnt get any API for transferring ownership to another user. but i got one RemoveUser API. i tried with the api https://smartsheet.redoc.ly/tag/users#operation/remove-user But i got the below error while using the above api…
-
Project Management/ Time/ Expenses
What is the best way to import time/ expenses daily and have them available for the PM to view on their project? Are multiple templates necessary in order to achieve this? Thx!
-
Extracting Data from Multiple Sets of Brackets IF present
This formula is working great for rows where the criteria fits - but my first problem is: can it be an IF statement so rows that dont have brackets are just blank? I cant seem to make it work? Second and third problems are, how can I parse the second and third sets of brackets into their separate cells for the same…
-
Showing information from Smartsheet A in Smartsheet B
Hi there, Is it possible to exactly show information from a source smartsheet to a destination smartsheet? Scenario - I have two smartsheets with exactly the same column headers. One smartsheet is for the whole portfolio and displays a lot of information, currently information is copied into it from the second smartsheet…