-
How To Build Report Based On Created Date
Hi everyone, I really need help of your expertise. I have develop one form and its purpose is to collect Facility Manager (FM) daily inspection on each floor. I have created one column "Created_Date" just to monitor new submission from FM. As you can see in "1.JPG" Each Question has yes, no and N/A answer. In "2.JPG" is…
-
Smartsheets Sending Mobile App Notification, but Not Email
I have a conditional alert set up in my form to send an email every time a row is added. When I use a form to add a row, it sends me a notification on my phone through the app, but it isn't sending me an email. I checked my spam filters and there is nothing in there being held. Has anyone else had this issue? This form is…
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Date criterion leaves out value in results
I am building a report from 2 sheets. When I add the When criterion "is a date" from Sheet 1, the report data does not display the existing, not blank Property value from Sheet 2. Both of these sheets use the same unique customer ID for common value. What am I leaving out? Thanks
-
Reports Using Start Date Criteria
I am trying to build a report that shows all projects by quarter - those that start after Dec 31 and before Apr 1 would pull into my Q1 report, for example. When building my criteria I only see to have the option to choose starts after Dec 31 OR starts before Apr 1. I need to change this to AND, but don't see an option for…
-
Report Builder who criteria with multiple contacts
I am building a report in SS and want to see the results for all projects that have both person A and person B assigned. When I create my search criteria, I am selecting both person A and B from the list, however SS automatically shows it as: Teams Impacted has Person A or has Person B How can I change this to 'has person…
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…