-
Fillable forms change formatting when generated.
Hi, I am generating a form with lots of data in it. I made the form on Adobe Indesign. I defined all the formats for the text (e.g. sizes and fonts.) Then, after generating the fillable PDF, when opening the form on Acrobat, All the fonts are set to Minion Pro and the size changes too. I tried to change the fallback font…
-
Public holidays duration
Hello everyone I am working on a use case and I have a problem with a duration value (using Smartsheet in french) : I calculated the number of working days for 2021 in France and it is 254, in Smartsheet I have a result of 255 As you can see below I have set up public holidays so I should get 254 days and not 255. It seems…
-
Weekly Report
Hi I have searched through comments but haven't been able to see anything that fits my need. I have a job applicant register that I need to report to Senior Management on a weekly basis the stats e.g. how many applicants have been successful etc picture of some of the things I report on attached. I have been able to…
-
Sorting
Hi @Mark Cronk ! Question for you, how would I sort the data shown below? i.e. so that the "Approved" are all together, and so on
-
Workspace Permissions
We would really like to be able to organize a bunch of sheets within a workspace. New sheets are going to be added routinely, and we very much want to take advantage of the inherited permissions of the workspace. Also, we would like for the sheets to be in the workspace and not constantly bombard our users with new sheets…
-
How to print date range for calendar view of report
When I print a calendar view of a report I am given the option to select a date range, but even when I select the date range, a four week period prints. Here I select just three days. But the PDF shows four weeks. Is there a way to only print the selected date range? Thanks!
-
turn a row in one sheet to multiple rows in another sheet
I want to create a "task list" so when I complete a row in one smartsheet(sheet a), I wat to break that into 10 "to-do" rows in a second sheet(sheet b). is there a way to do this? essentially what I am trying to do is for every row in sheet b, I want to send a separate request for update. i have datamesh if that will help
-
Sumif with a date range
I am trying to calculate the billing amount for an individual month when there are multiple months in the column. Below will calculate all of the billing, but I want to call out 11/2020, 12/2020, 1/2021. What can I add? =SUMIF({Monthly Detail Range 1}, [Primary Column]@row, {Monthly Detail Range 2})
-
Comments in report widget
Hello, I have a dashboard upon which I am displaying a report using the report viewer widget. However, I am unable to select the "Comments" column as on of the columns to appear on the widget. Our team members post status updates and actions to the "Comments" for each item on this sheet, in addition to the "Status" column.…
-
Move Row Data Automatically Within a Sheet
Hello, I have created a spreadsheet to track admission data into our facility. I used the TODAY and TODAY +1, etc.. function to show the correct date. I also used the IF(WEEKDAY) function to show the day of the week. What I am trying to do now is make it so the row information from those dates moves up automatically. Based…
