-
Calculate first working day of a month
Hello I need 2 formulas please to calculate (1) the first working day of a month So - 1 December 2024 is on a Sunday, I want the returned date to be 2 December 2024. 1 November 2024 is on a Friday, I want returned date to be 1 November 2024. (2) the first Thursday of a month So for December 2024, the returned date should…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Présentez-vous & et faites connaissance avec vos camarades !
Bonjour, Faites connaissance avec les autres membres de la communauté et prenez une minute pour vous présenter dans les commentaires ci-dessous. Vous avez besoin d'un peu d'inspiration ? Dites-nous d'où vous venez, votre rôle, comment vous utilisez ou espérez utiliser Smartsheet et un ou deux faits amusants à propos de…
-
What are some fun and unique ways you use Smartsheet?
I’d love to hear the creative ways the Smartsheet community is using Smartsheet for fun or unique ways, whether at work or in your personal life! Have a story to share? Drop it in the thread! One of the best parts of hosting user groups is getting to meet amazing customers and hear their stories. Here’s one of my favourite…
-
Unable to open smartsheet backups
I have a few workspaces scheduled for recurring weekly backup. These backup downloads used to work perfectly , until we started to notice a change in how these downloads were available to us. I understand that I need to use the link from the "Smartsheet Backup Complete" and follow the procedures set. " Click here to…
-
Index Collect criteria with MAX latest date
Hi, I've been hitting myself over the head for not 'getting' it, I think i'm doing the correct thing, but obviously since I'm reaching out, I am NOT ;) If you would be so kind, please enlighten me on my error. In a sheet summary I'm trying to do the following: =INDEX(COLLECT(ReportSummary:ReportSummary;…
-
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
-
Document generator - Font/Data error
The smart sheet document generator is showing erratic values; it used to work fine previously; however, any new document generated now creates an error; if I type ABCD in the smart sheet cell and then generate through the document generator, it will show something like (e^pp^k or olp^ifb) instead of ABCD as desired. Any…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
Upcoming Resource Management Webinar- Register Today!
📣 Exciting things are happening with Resource Management by Smartsheet! Join us Tuesday, November 19, to dive into the latest features we’ve launched in Resource Management, get your questions answered, and even hear about a top-requested feature we're about to reveal (🔎hint: it rhymes with “phase integration).” ⭐️ Secure…
