-
Determine entries in a dropdown from a formula
Does anyone know if it is possible to select each item in a dropdown where you might have one or more entries, and separate each one in a formula to calculate hours * rate? Or a work around if possible. My current formula works fine for one entry as follows with the [Assigned To] column: =SUMIFS({KCPL Hours _#OF HOURS},…
-
Question: Can you identify the worksheet behind a form?
The subject really says it all. I know I can go into a worksheet and identify the forms created for it, but can I do the reverse or do I simply have to check every worksheet until I find it?
-
Search for Hyperlink
Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its not finding anything on my sheets. Any workaround for this? Perhaps there is a way to create a hidden column and a formula of…
-
How do I give an outside user access to ONE row of a spreadsheet?
Here is the deal. I run a wedding video studio. I just made a smartsheet questionnaire (form) to have all of our videographers answer from the smartsheet app on their phones at the end of the shoot to inform the editors of anything they need to know about, etc. One of the questions asks them to upload photos they took from…
-
Formatting the Custom Message in an Alert
I would like to send an alert to each of my team members weekly at 2:00 pm on Thursdays. I created the form, and copied the URL. I created the Automated Workflow to send an alert to my team members, and include the URL in the Customized Message. When I tested this, the customized message, with three short paragraphs…
-
Index/Match always returns the same
Hi all, Been searching on the community but could not find an answer to my issue. Sorry if i missed it. So i have a Master sheet for the sales team, with all the customers to contact, with one rep allocated on each of those customers. Then, the individual reps will have their own spreadsheets with only their allocated…
-
Sorting by Date in Exported Excel File
When I export a sheet (Gantt Chart with timelines) to Excel it doesn't seem to sort (e.g. by date) all the rows when indented Task Names are present. It will only sort the highest level Task Name, but I would like to sort all the rows regardless of the Task Name hierarchy. Is there a solution to do this, or possibly a…
-
Inconsistent Formula Function (seemingly, anyway)
I wrote a formula to calculate the number of days until a task is due. It works perfectly most of the time, but, on some rows, it doers not. Below are the actual copied and pasted formulas from the cells that say "OVER-DUE" and "-2, referenced from the screenshot: =IF([Task Total Hours]26 = 0, "", IF(Finish23 < TODAY(),…
-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
Smartsheet template with approval request
Hello, We will need to create multiple number of sheets periodically and thinking of creating them from a Template. The sheets will be quite basic/plain - mainly contain free text, drop down list, number and dates. I am quite sure this can be accommodated by the template. Can the template also cater for Approval requests?…