We have a change order request form for our suppliers to use when requested a change in the design or scope of our projects. I have an automatic workflow to send the request for approval to our construction manager(s). When they approve (or deny) the request, the status changes to approved (or denied) .. but I cannot seem…
We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please help?
Is there somewhere we can get all the Smartsheet Icons for use in Miro? Something like these below.
I have a Smartsheet organised by hierarchy, I want users to be able to enter data but only to be able to see their own group (represented as top level hierarchy), my understanding is the correct way to do this is to create a report. But how can I filter the report so it shows a named top level hierarchy and all the…
Hi, I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets. How do I reference the columns as a range and a value? The formula should be as follows: (in cell B2)…
Thanks to all who joined us for our "Ask Me Anything" session with Dan Bloom! We had a lot of great questions and look forward to hosting more of these sessions in the coming months! Missed the session? Please read the below to get some additional information about Dan Bloom and head over to our Marketing Group to view…