-
Adding a $ to a Reformatted Number ending in "M" (Millions)
Hi, I am trying to convert a number in millions but shown as a thousand to the nearest decimal point and then add "M" to the end of the converted number. I understand the formula to divide by 1000 and then use the ROUND function to get one decimal point,but when I concatenate the "M" at the end I loose my dollar sign. Does…
-
Resource profiling
I have a requirement where each task requires a % allocation profile instead of the standard flat % allocation throughout the duration of the task - is it possible to set this up? For example, a task is 9 months long: Month 1 requires 50% Month 2 - 6 requires 100% Month 7-8 requires 50% Month 9 requires 25%.
-
Pulling Tasks into a Report Using Multiple IF(AND( formulas in the same cell
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
-
Card View - Summary Rows & Totals
I'm supper excited about Card View but I can't figure out how to do the summary rows that are presented in the introduction video. Is this a setting? a series of formulas I need to do? do they happen automatically? thanks!! https://help.smartsheet.com/articles/2302238-using-card-view-to-visualize-your-project
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Is there a way to know current sort criteria?
I got invited to edit a sheet, which I'm pretty sure is sorted. The sheet has way too many columns for me to quickly check the criteria. Is there a way to know what criteria the sheet is sorted on?
-
Overlay Google Calendar in SS in a grid
Im going to implement a time management report in the company to understand how the staff spend their time (meetings, planning, execution, travel, etc) To do this we use a name code in Google Calendar that enable us to automate the analysis, like this. * All meeting start with MEETING... * Task-related to projects starts…
-
QlikView With Smartsheet Connection
Hello Folk's. I have to connect qlik with a Smartsheet table, passing its credencials. I know that there is a connector in QVsoure which is also Qlikview tool, but the company is not willing to spend money on it now Is there a possibility to connect with it via REST? Thanks,
-
Feature Request: Changing Rows in Scheduled Update Requests
It seems as if there's no way to change the rows to be updated in a recurring update request, currently. I think that this is very inconvenient and undermines the power of recurring requests: * I don't want to bother project managers with requesting status updates on already completed rows * I don't want to bother them…
