-
Smartsheet Update Requests with Automation
I set up and automation to send an update request and sends to a Contact field. Works perfect except that is doesn't bundle the requests by the Email in the Contact field (sends each request as separate emails). I think this is acting as designed but wanted to ask the community if anyone has been successful bundling…
-
Dynamic Column Reference
Hi! Lets say I have a basic formula like this in a "budget" column: =SUM([Week 1]@row:[Week 10]@row) And I also have a cell in a helper column that includes this formula: =WEEKNUMBER(TODAY()) Is there a way of [Week 10] changing to [Week X] based on the number in the week number cell? I have a column for every week of the…
-
Formula Handbook Access
The Handbook for formula is refusing to download on my Smartsheet App, how can I access it?
-
Assistance with #Unparseable error.
This discussion was created from comments split from: Find and Highlight duplicates in column.
-
adding another column to calculate hours
Below are the references and the formula I am using to calculate "Offsite supervision hours" and automatically sum any hours that fall in the same week. But I also need the sum of the hours to go to different sheets based off which department/s are assigned… LVM8HD, LVM10HD, LVM12HD are referencing a cell that contains how…
-
Need help to prepare a report which shows the In Progress/On Hold tasks, along with the Parent task
I am trying to create reports which will show tasks in various status - Not Started, In Progress, On Hold, Complete. But when I run the report, it is fetching the actual tasks only, but I need to capture the parent task also. I find no issue with In Progress tasks, because when I filter for the In Progress tasks in the…
-
Multi data report comparison
I am looking to identify when new items are added to a report. We receive a report bi-weekly and the goal is to 1. compare the new report the previous report to identify when new items that meet the filter conditions are met and 2. take the newly identified items against the assigned list and if not found, then add to the…
-
Nested Criteria
I am trying to count all "Implemented" and "To Implement" instances in "CS Status" drop down for the current month and year ("Created Date"). I keep getting nested criteria error. I am sure I have put too much information in but can someone help please? =COUNTIFS([Created Date]:[Created Date], AND(IFERROR(MONTH(@cell), 0)…
-
Formula Copy/Paste Issue
I have the below formula to extra a Quarter based on my column "Expected Close Date". The fiscal year begins 10/1. When I copy the formula to other rows it displays the same number (i.e. January showing as Q4 when formula is pasted when it should be Q2. =IF(MONTH([Expected Close Date]@row) >= 10, "1", IF(MONTH([Expected…
-
Smartsheet Core product certification
I recently passed Core product certification almost 2 weeks back but I am yet to receive my certification badge or online certificate. Not sure what is the process to get either a physical or digital copy of my certificate. Appreciate anyone's comments on next steps.