-
Need help to auto populate a formula to display a number
It is simply EYYWK## -YY= year (e.g., 24 for 2024) -WK=week (e.g. 15 for right now. The 15th week of the year) -##=sequential e.g., 3x E-runs have been created this week, so the last "Full# in the book is E241503
-
Allow to send attachments without linking to the sheet and adding other Smartsheet details
For business use, the automated workflows to send automated email messages is wonderful. However, the emails that can be generated if you want to include an attachment from the sheet is unprofessional, messy, and confusing. I love the look of the emails when you send just the message. I wish I could send a message and…
-
Help with Formula
I'm working on a formula that will look at cell A if it is = "Milestone" perform this function, if not do this. Have that working. My issue is if the denominator is 0 is produces an error. I would like to add code to return 0 if denominator is 0. The top code is what I need to figure out. The bottom code is what is…
-
Countif reference range
I would like to know when in January an issue was logged. Both my month and Issues are referencing another sheet. I want a count of January issue looking at columns Issue 1 through column Issue 4 (four column range). This works - =COUNTIFS({Month}, "January", {Issue #1}, "002_Bypass Audit") Does not work -…
-
Smart Forms Templates
Is there any Smart Forms Templates that can be used? I wanted to make a smart form that allowed the easy use of Contractor SOW form or something similar to it. I wanted to be able to have contractors fill it out and state their information such as, certifications relevant to work being completed, personnel on site during…
-
Adding a editor
Hello, I have bough PRO licence. It shows that up to 10 editors are included. But when I try to add the editors, it shows me, that there are 0 licences available. What does that mean? Are there editors included or do I already need to buy more licences? Right now only 1 user can see the sheets.
-
Enhancement Request: access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
How would you most easily track that a date has changed to a new date that is 'x' different (+,-)?
We are using data shuttle to bring 'start date' in from another system (upon attachment for now; eventually, most recent when it sees it). If the start date changes we have users who want to know if it moved up 10 days, back 3, etc. I can create a hidden column to hold information and calculate - but I can't figure out how…
-
Best Way to compare budget numbers
Hi Communnity, I have been tasked with adding a visual to a dashboard that would compare metrics reported monthly via a form (automated) to a fixed budget amount to show if the entity is on track/over/under etc. What would be the best way to do this - I would want it to automatically populate Thank you for your help!
-
Automation Advanced Options
I was automating a sheet and "Please set the approval settings via 'Advanced Options' popped up before I could save it so I clicked into "Advanced Options", but even after editing them, it won't allow me to save it. I receive another pop up that says "Enter unique dropdown text values, and unique button text values" No…