-
Totaling up Days between Dates
Hello, If someone could assist me please that knows how. I am trying to get the total days calculated automatically between two dates. i.e 1st Sept 2019 to 15th Jan 2020 - How fo I get the total days calculated. Do let me know please. Thank you
-
Corresponding cells
Greetings, I have an end date column and a delay column in some of my smartsheets. I now need to add some of these delays to one of my duration cell (which gives the overall duration of my project (cell in pink highlight)). Suppose, item A, item B and item C were supposed to arrive on the 1st, 2nd and 5th of a month (in…
-
Voting on a Worksheet
I have a sheet that are shared with a group of 25 members, which contains multiple line items that we are currently collaborating on. The purpose of this sheet is to collect the items and publish a requirements document. Part of the collaboration effort is to get all users to cast their votes against each line item so we…
-
iOS app allows editing of some dates but not others
I’m traveling this week and only brought my phone and tablet. I downloaded the app assuming I’d be able to use it to edit my schedules, but for some reason some date cells are editable and others aren’t. As luck would have it, the active date cells are the ones I can’t edit, the “planned” date cells, which are permanent…
-
Cell links lost when column type is changed on destination sheet
Has anyone else run into this? Is this a normal function? I had a checkbox column in my source sheet and one on my destination sheet. The theory was that a box would be checked if certain criteria was met at least once anywhere on a sheet. This was put into a lot of sheets. The sheets were then listed out as sort of a…
-
Recurring Update Requests until task is complete
I have a workflow where a contact is sent an updated request when they are added to the row. What I would like to know is how to have that update request sent regularly (daily, or weekly) UNTIL they have submitted the update request. Then I don't need them to get the update request anymore. Is there a way to do that?…
-
Child Text Indented formatting
When you have a Heading Row and Rows below that are Children of the Heading Row, is it possible to have the text Left Align and not be indented? Thanks, Tm
-
Form Issue: Auto-Complete Contact Column
Hi All, I think this feature should be a part of the Smartsheet web client, however, it is not. BUT it is a part of the mobile app. When I go to type someone's name into a contact column field USING A FORM, it won't auto complete and show you a drop down of available contacts. When you use the mobile version and are…
-
Smartsheet Form and Outlook Calendar Item
I am wanting to have a form for individuals to sign up for a workshop and would like to include an outlook appointment in the form so that they don't have to create the appointment in addition to signing up. Is anyone aware of how I could do this?
-
Some Vlookups returning #NoMatch, others are fine
I have a training tracker with all the staff, their managers, locations and whether or not they have completed training. I have multiple vlookups in columns manager, location, role, status and classification. The vlookups are referencing an HR file that we have that has all the raw information. As you can see below, many…
