-
Formula help for previous month
I have a helper column for a report that I want to check the box if the DATE cell is in the previous month. Any help is appreciated!!
-
Anyone else having issues with Forms in Smartsheet Government?
We use a variety of forms in Smartsheet Government, these forms worked seamlessly until they pushed a form update (18 Dec). While I love the new features, the forms are no longer accessible unless the user is on our domain or using our VPN (very few are as most of the users are external to our organization). The help desk…
-
Forms Logic in GOV instance of Smartsheet
Smartsheet Gov does not currently offers forms logic. Having the ability to use logic would be highly beneficial for so many intake processes I do on a daily basis. Instead I am forced to use Microsoft Forms since that functionality exists. I don't like using Microsoft Forms! Please add Forms Logic to Smartsheet Gov.
-
Modern Forms with conditional logic is now available on Smartsheet Gov!
Hi Community, We’re excited to announce that Modern Forms with Conditional Logic has come to Smartsheet Gov! Modern forms with conditional logic in Smartsheet Gov empowers your team to collect and act on information faster and with greater confidence on the Smartsheet Gov platform. Ask the right questions to the right…
-
Why is my chart blurry on my dashboard?
I recently tested the Chart widget and like the functionality, but I can't ignore the fact the text is blurry. People I have shared the dashboard with also have remarked on how blurry the text is. Is this a problem others have experienced? Is there a fix?
-
Keyboard shortcut indent after CTRL+K went away
Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyboard ( ] = AltGr 9) Ctrl AltGr 9 just types the symbol ]. Anyone else struggling with…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
Can I used conditional formatting to high duplicates in reports?
We have several grant programs within our organization and I am working on funneling all the form submissions from each into a main report. I would like that report to identify duplicate submissions so I can consolidate and make sure candidates aren't overwhelmed by having too many cases open. Can I use the conditional…
-
Pivot App Available for Government Edition/Version
We utilize Smartsheet's to allow for collaboration, reporting, and dashboarding across various entities. It would be useful to allow a pivot app option in the government edition/version to summarize content for managers/stakeholders and would be useful for summarizing data for use in other Smartsheet developed dashboards…
-
What's the best tool to track simple request that comes to our legal office?
I work for a government agency and I'm in charge of tracking questions that come to our office, like what the question is, the topic, who is handling it, date of request and date completed, how much time it took (e.g., 15 minutes or 2 hours). Then maybe create reports on the type of questions that came in, how many request…