-
formula not working on row1
Hi , Can anyone help why the formulas are not working on row1.I mean i am not able to use any formula on row1 Thanks
-
Uploading Dropdown Choices from a source file in Data Shuttle
What format does the source file need to be in order for Data Shuttle to upload dropdown choices? I know it needs to be a .csv or Excel file, but what does that file look like? All all values in a single entry or are they delimited? Maybe I am missing something, but this is not very clear to me.
-
Column ID Visual Representation?
We have a sheet with many columns - it can be challenging at times to navigate, given how large it is (unfortunately, necessary for our use case). As standard, there is a built in 'Row ID' or Row counter on the left side of the grid that outlines the row number. Is there any function or feature that could replicate this…
-
Sending approvals through email?
I see that Smartsheet has the ability to let someone know they have a task due by sending them an email with the task details. I am wondering if it is possible to subsequently send an email on Due Date +1 to say "you had this task due yesterday, was it completed?" with a Yes or No button for them to click. If they click…
-
Copying Rows To the Top of Another Sheet
Hi All - Is there any way to use the Copy function, from one sheet to another, and have it copy to the Top of the sheet it's going to?
-
Control for Character Entry on Form
Hi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese characters then have to translate later. Would prefer to restrict on the form itself.…
-
Formula for 2 columns - checkbox and a date range
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the…
-
automation to update a date field to new value
Hi, I am trying to set up an automation where it detects when a date found in column DATE is passed and then would automatically update it based on the value found in the column frequency for example : if the DATE = 01/07/2021 and the frequency = Weekly then when we pass the date 01/07/2021 it should automatically change…
-
Logic Project Plan
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50% Can any one help on…
-
Data Shuttle / Only works once with manual trigger
New Data Shuttle user here... Background: Pulling from an Excel file stored in my OneDrive. No automation at this time, triggering the upload manually as I test the approach. Issue: I can get the initial data pull to work just file. When I update the source data and manually trigger a second time I get a successful run…