M. David
M. David
Reactions
Discussions
- Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say …
- Is it possible to send an automated alert to a group? It looks like the only options are to specific people, contacts in a cell, and everybody shared to the sheet. I have two groups shared to the shee…
- Hello, My experience thus far with Smartsheet has been as a Systems Administrator for the last four years. Prior to my even learning Smartsheet, I had this idea for an app that would help to streamlin…
- I have three columns with the below formula in the "Helper - Overdue" column. This works correctly for when there is a date in the "Deadline" column and the "Item Completed" box is not checked. It als…
- I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would…
- I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sen…
- I have a formula in the "Health" column of a sheet. This formula shows a colored ball depending on the "Status" of another column. The "Status" column is determined by another column, "% Complete". Ul…
- This is a weird one that I couldn't find any help on. I have two sheets. On the first one is a bunch of data and formulas, but the end result is a column with the number of miles each person has walke…
- I have a sheet that will be collecting data through a form. We want an email to go out to a team of people every Sunday morning as a reminder for them to complete the form for that week. It should inc…
