-
#Invalid Operation Error subtracting days from another Date field
I have a sheet that has a date field that is link in from another sheet (actually 2 other sheets) that is not working as expected and I cannot seem to root cause the issue. I have a column 75%/SD Date that I want to get 14 days before it in another column. Below are some things I have put in for the formula and the result…
-
Is there a simple way to manage workflow approvals when the approver is out of office?
I don't want to have to go into each workflow and update when my workflow approvers are out of office, on vacation for example. Ideally, I would like the approvers to update the dates they are out of office and provide a delegate for the approvals that are received in this timeframe. Any approvals required during this…
-
Sheet summary can be added to a report
I have created a report from 3 different smartsheets to merge it in a single sheet report. This report shows in a single view all our Purchase Orders from 3 different line of business Now I'm creating a dashboard to show quarterly trends (i.e. # requisitions submitted, # of requisitions completed and total requisitions…
-
Webform Dynamic Columns
This is a question that I'm almost 100% I know the answer to, but before I give up entirely, I'll ask the question here and get the definitive answer. Is there any way to set up an update webform with dynamic columns? For instance, say I have 4 columns on a smartsheet: Name, Age, Favourite Colour, Pet, Date If I set up an…
-
Customized Dropdown LOV Per form
Hi, Can I customize the LOV of a dropdown menu in a form to be form specific? For example, on a sheet, columnX has 1,2,3,4,5,6. I want to create 2 forms, form 1 shows columnX 1,2,3 only, and form 2 shows 4,5,6, without the need to split columnX to two columns, as a workaround. Thanks! JT
-
Formula
I am attempting to sum in Summary the total amount spent on a trip by individual deapartment in this calendar year. I have the following: =SUM([TOTAL ESTIMATED COST]:[TOTAL ESTIMATED COST], Department:Department, "Trauma Healing Enterprise", [Return Date]:[Return Date], YEAR(@cell) = 2020)) I am learning as I go so this…
-
Dynamic view filter by project type
Hello everyone, Do you know if it is possible to filter on a specific column in dynamic view ? I have a sheet with a list of projects, and I would like that each project type team has only access to its projects. For example, I would like that all the users of my internal projects team can only see the list of project type…
-
Ratio of Completed Subtasks Not Updating, in Card View, When "Subtask Checkbox Field" Selected
I've added a "Subtask Checkbox Field" in card view settings. When I define subtasks, and subsequently set to "Done", the ratio of completed subtasks in the card view is not updating. Will appreciate any guidance you can provide - thanks!
-
Having a checkbox to quickly complete rows
I don't want to presuppose how this problem should be solved, but basically I'm wanting to be able to quickly complete simple tasks with a checkbox, rather than having to set complete% to 100%.
-
Data missing when moving rows?
Hi there, Has anyone noticed an issue with data missing when moving a row from one sheet to another? I have an automation that moves older rows in one sheet to an archive sheet once a month. However, it appears that data in at least one of the columns is missing. Any ideas what might cause this? Thanks! Jackie
