-
Countif formula for multiple items in parent row
Here is my table: In the Gender ID column I'd like to see a count of M and F in both the 1st and 2nd hierarchy rows. For example, in first row, K, it should end with M-2 and F-0 and the same in the 2nd row, Frizzle. For the row, 4, it should return M-3 and F-3, but under row, Dumbledore showing M-2, F-1 and Yoda M-1, F-2.…
-
Allow free users to edit a filtered sheet or report
How can I share a filtered sheet, or a report, with a free user and have them be able to edit it as well? So far all I have found is the ability to make a filtered report and then share that, however I need to share the source sheet as well then, thus defeating the purpose of the filtered report, since I only want this…
-
Resource view duplicates?
Each project I am assigned to shows twice in y resource view. Its the same for everyone. When I go to the sheet thee is only one. I deleted myself which removed a duplicate but the same sheet where I deleted myself shows me still there (the one left)? This was not happening before, only noticed today. Any ideas?
-
Submit Bottom on Sheet
Hello, I'm trying to figure out a way to give indications to doctors to save the sheet before they exit. The intake sheet can't be a form, as I have images and over 100+ lines. I'm thinking of a visual cell with clickable formula may be. I'm open to suggestions. Thanks,
-
Changing ownership makes Chart Widgets turn to Missing Source
As the Smartsheet Admin, I create most of the Sheets, Reports, and Dashboards for the Executive team. When we transfer ownership of all Sheets, Reports, and Dashboards to the Executives, their Dashboard Chart Widgets all state "Source Missing". Smartsheet's Help Desk provided this response: "... you may need to transfer…
-
Automation - Copy row to current sheet
I have a user-oriented form associated with a sheet. The sheet works as it should, but we have a specific workflow in our business where a user may need to immediately enter a nearly-identical form immediately after submitting the first form. The form has dozens of fields and the second submission is identical in all but…
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
-
Find (CTRL+F) Values in Contact Column
It appears impossible to find values in a contact column using a CTRL+F/Command+F find function. I've attempted searching by the contact name (Joe Smith), contact email (joesmith@company.com), and even the messier value that copies and pastes out of a given contact cell (Joe Smith <joesmith@company.com>). I need to find…
-
alert with specific row
How can I set up to send an alert for specific row when it matched a condition . I tested it and it triggers correctly but always send the first row. for example, it should send out the 10/10/2022 row only, but it sends out 10/2/2022 row any idea? Thank you
-
A cross sheet formula that reference back to the main sheet?
Hi all! I'd be very grateful for your help... I have a Smartsheet where I would like to have an index match or vlookup formula or similar, which references a secondary sheet. The problem is that the relevant field in the secondary sheet contains a formula that needs to reference back to the main sheet. I have made up some…