-
Create calendar and dynamic document generator
Hi all, Trying to create a database that does the following: 1 - Each crew member has their own line, and within it you can select what they are doing from a dropdown menu each day 2 - Have a report that summarises who's doing what on a given day 3 - Based on today's date ie 18-8 create a dynamic "Generate Document" form.…
-
Pulling weekly data
Hello, I have a sheet that looks like the image below, where employees show a complete or denied status for the date (column 3 is a helper column referring to the parent). On another sheet I'm trying to pull how many employees are "Complete" for the current and following week (there is only one date per week). I tried with…
-
How to combine an IF statement with Workday and MAX functions
Hi Friends, I'm currently using the MAX function to determine the "Next Maintenance" date based on the "follow-up" columns as shown below. I'm looking for a way that if its output has a date of a weekend, it would automatically populate the next Monday date. As an example below, the next maintenance date coming from the…
-
Count boxes checked based on specific data in another row
Hi all! I have columns labeled "Inside" and "Outside" that are check boxes. I have another column for "Install Status". In my Summary data, I need to count the number of Status that are "Complete" that are checked for "Inside", and the number of "Complete" that are check for outside. I tried this but is not working:…
-
CountIFS for smartsheet (Excel formula translation to smartsheet)
I have an excel formula that calculates the the number of days by month and status. =COUNTIFS($E$1:$E$100,">=Aug 01 2021",$E$1:$E$100,"<=Aug 31 2021",$G$1:$G$100,"=Not Started") When I translate this formula into smartsheet it does not work. =COUNTIFS([End Date]1:[End Date]100,">=Aug 01 2021",[End Date]1:[End…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Project schedule regarding crew size
In Microsoft project I am able to add crew sizes. When I change the crew sizes, it adds days or subtract days from the duration. Does Smartsheet do the same?
-
Creating Report Workflow Automation that goes out on the 3rd Friday following a Monday
Basically, I can only use weeks where there is a Monday in that month before the 3rd Friday. So the native function of picking 3rd Friday will not work for this scenario. I have seen lots of help for Monday's but am not sure how to program this one. I need to send out a report reminder to owners the 3rd Friday following a…
-
How to display the value of column A once a value is found on column B?
Hello All, I'm new on smartsheet and I'm having difficult to find (or express myself the correct way) articles that are displaying what I need. So I need your help. I do have a master sheet with several pieces of information. On a Column A I do have customers names. Column B I do have a multiselection cell where these…
-
Formula help to view a specific month
Hello, I currently have the formula below. Curious if anybody could help me change the formula to be a specific month like July, June, September. Any help is appreciated =SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, =MONTH($[Column9]$26))